Using Bill Tracker in QuickBooks
Using Bill Tracker in QuickBooks
SCHEDULE A CONSULTATIONUsing Bill Tracker in QuickBooks
Bill-paying may be your least favorite accounting activity. You definitely know how those checks and online payments affect your account balances, but it’s more than that. Staying up to date with your bills and paying them on time (but not too early) takes a supreme organizational effort.
If you’re using a manual bookkeeping system, you know how difficult it is to keep up. QuickBooks offers several options for helping you with this. You can set reminders and/or put the due dates on your calendar. If you’re using QuickBooks 2016 or later, you have access to another tool: Bill Tracker.
A Comprehensive Overview
QuickBooks Bill Tracker is similar to the software’s Income Tracker. If you’ve used that, you know that it provides a way to get a birds-eye view of your accounts receivable. You can see where every transaction falls in your income “pipeline” (estimates, open invoices, etc.).
Bill Tracker works similarly, but for accounts payable. It has two advantages over just opening your Vendor Center and clicking the Transactions tab. First, it displays the Status of each transaction. Second, it contains Action links, so you can do more than simply open each entry.
Figure 1: Bill Tracker lets you switch between lists of different types of accounts payable transactions.
To open this tool, click Bill Tracker in your navigation pane. The screen that appears consists of two parts. Color-coded bars across the top represent different transaction types, Purchase Orders and Bills. The latter is further divided into Open Bills, Overdue, and Paid In The Last 30 Days. Each bar contains both the number of transactions that fall in that category and their total dollar amount. Click on one, and the list below changes to include only that type of entry.
You can see in the image above that the Open Bills list has three alternate views that you can open by clicking on them in the drop-down list: Item Receipt, Credit, and Unapplied Payments. If you have questions on any of these, please call and QuickBooks professional can explain them to you, since you should know when to consult these lists.
Changing the View
Bill Tracker defaults to the broadest view possible. That is, when you select a category of transactions, it shows all of the active ones. But a series of drop-down lists below the main toolbar gives you control over what subset of information is displayed there. You can narrow your list down to one vendor, for example, and choose a date range.
Data columns are different for each list. When you’re displaying Overdue transactions, the labels read Vendor, Type, Number, Date, Due Date, Aging, Status, Amount, Open Balance, and Action. You get a thorough description of each entry at a glance.
Taking Action
As was mentioned earlier, Bill Tracker lets you work with transactions as well as just view them. Click on Purchase Orders and open the drop-down list at the end of one of the rows in the Action column. You can see in the image below what your options are there, including Convert to Bill. When the Open Bills list is active, you’ll be able to click on Pay Bill.
Figure 2: Open the drop-down list in the Action column to see what you can do with the selected transaction.
To see what else you can do with individual transactions or groups of them, look in the lower left corner of the screen and locate the Batch Actions and Manage Transactions buttons. With the Purchase Orders list open, click in the box in front of one or more to create a check mark. Open the Batch Actions menu. You’ll see that only two options are available to you here; the others are grayed out. You can Print Selected Purchase Orders or Close Purchase Orders. Pay Bills is only active when you’re in a list that allows that.
Now, open the Manage Transactions list. You can create transactions from this menu by clicking on Purchase Order, Bill, CC Charge, or Check. If you select Edit Highlighted Row, the original transaction will open.
Remember that you should never write a check to pay a bill if you’re using QuickBooks’ bill-payment tools. If you’ve already entered the bill, click Pay Bills on the home page or open the Vendors menu and select Pay Bills. Please call if you have questions about this process.
QuickBooks offers multiple ways to take the same actions in accounts payable; Bill Tracker is just one. But this instant overview can tell you quickly where you stand with your vendors — and help you avoid late payments. As always, help is just a phone call away.
Talk to one of our Accountants Today
OUR SERVICES
Accounting
- Statuary Accounts
- Management Accounts
- Bookkeeping
- Business Plan
Tax
- Tax Investigation
- Capitol Gains Tax
- Tax Advisory
- Corporation Tax
Consulting
- Registered Office Address
- Company Formation
- Company Secretarial
- Legal Helpline
QuickBooks/ Bookkeeping Services
All of the financial information and data for your business should be organized and in one place so it is easy to access. With our bookkeeping services, we will organize and manage your financial information within the QuickBooks software so you can easily access it at any time. While we manage your financial matters on a daily and monthly basis, you will be in control as we will keep you updated and ensure you can access and monitor your finances. If you are applying for a loan, doing your taxes, or budgeting, having quick access to your financial information is important. We can assist large businesses and provide small business bookkeeping.Advisory Services
Our accountants can take on an advisory role with your company through our business consulting services. We will work with you to understand your financial goals and help you make the right decisions to reach your goals and help your business grow and become more profitable. Our business advisory services include advisement for investments, taxes, payroll, bookkeeping, administration, and more.Estate Planning
It is important to manage your estate to help protect its value and ensure that your assets are distributed properly between your beneficiaries. Our accountants can assist with your estate planning, including managing the taxes to preserve its value and ensuring that your assets are distributed according to your wishes. Our estate accountants will identify ways to protect your estate from inflation and taxes and minimize what you are paying in taxes to maximize its value.Sales Tax / Nexus
Sales tax rates and laws are decided locally and differ between states and cities. This can make sales and use tax difficult to manage for businesses, especially those that operate in multiple cities and states. Our certified public accountants can help manage your sales and use taxes by ensuring that you are in compliance with applicable sales tax laws and identifying opportunities for refunds and exemptions. We have a thorough knowledge of sales tax laws and we can even help businesses that operate in multiple states with filing their taxes. Using Nexus tax analysis, we can help multi-state businesses stay in compliance with all applicable tax laws.Payroll Services
We provide payroll services to small businesses and international businesses that operate in the U.S. Our accountants will streamline your payroll process and manage the tax withholdings and benefit deductions from employee paychecks. We can also file the tax returns for your business that account for the tax withholdings.Call the CPAs of STE Corporation
Contact our CPA firm if you want to work with our accountants to help manage the finances for your business in Park Ridge, IL. You can call STE Corporation at (815) 836-0100 to talk to our professionals or schedule a free consultation.FREQUENTLY ASKED QUESTIONS
WHAT OUR CLIENTS SAY ABOUT US
“Everyone at STE has been amazing. As a small business owner it is essential to have people on your team that are experts in all areas. When it comes to finance and taxes Jim and the team at STE fill that need. Thanks for being great at what you do and always be there!”
“STE has been handling our personal, business accounting, and payroll for years. They are knowledgeable, easy to reach, and very welcoming. Would definitely recommend them.”
“I have had nothing but pleasant experiences at STE. They are knowledgeable and provide great service.”
“We have used STE Corporation for our payroll and tax service needs over the past 3+ years and extremely pleased with the partnership we have created.”
“My husband has operated his painting business since 2004, first as a sole proprietorship and later as an S corporation. STE has been instrumental in helping him grow his business and remain in compliance. I cannot thank Mike, Marybeth, Jim, and Lisa enough for helping him get organized and stay that way. They have truly been the business office he needed in order to focus on the part of his business he enjoys – painting and customer service Their professional staff literally have never let him down – payroll, state taxes, federal taxes, consultation, ledger reconciliation, profit and loss sheets, and probably lots of things I do not even know about! Hiring this firm was the best decision he could have made. He looks forward to visiting the office, everyone makes him feel like family. I appreciate their professionalism and efficiency. Thank you STE!”
OUR SERVICES
Accounting
- Statuary Accounts
- Management Accounts
- Bookkeeping
- Business Plan
Tax
- Tax Investigation
- Capitol Gains Tax
- Tax Advisory
- Corporation Tax
Consulting
- Registered Office Address
- Company Formation
- Company Secretarial
- Legal Helpline