Keeping Up With Receivables: Know Who Owes You
QuickBooks Online provides numerous ways for you to know which customers owe you money – and who is late.
There are so many financial details to keep track of when you’re running a small business. You have to make sure your products and services are in good shape and ready to sell. You have to stay current with your bills. Orders need to be processed as quickly as possible, as do estimates and invoices. And you may have numerous questions from customers and vendors that must be addressed.
Your number one priority, however, is ensuring that your customers are paying you. Whether you accept credit cards or bank transfers or issue sales receipts for cash and checks, you need to always know where you stand with incoming payments. “Are my receivables current?” should be a question you’re asking yourself or your staff frequently.
QuickBooks Online offers numerous ways to know whether you’re being paid for your products and/or services and who might be falling behind. That information is critical to your understanding of how your receivables are stacking up against your payables. You should be able to gauge whether you’re making a profit, staying even, or losing money. Here’s a look at the tools you can use.
Learning When You Launch
QuickBooks Online provides a good overview of your current cash flow as soon as you log into the site and see your two-pronged Dashboard. The first thing you see when you click the Business overview tab is a cash flow forecast that goes up to 24 months. Other content includes a profit and loss graph and charts showing expenses, income (including open and overdue invoice totals), and sales. Your account balances are there, too.
This is helpful data, but it’s broad. To get far more detailed information, hover your mouse over Sales in the toolbar and select All Sales. The horizontal bar across the top displays dollar and transaction totals for estimates, unbilled activity, overdue (invoices), open invoices, and (invoices) paid last 30 days. When you click one of the bars, the list changes to show only that particular set of transactions.
Partial view of the toolbar at the top of the Sales Transactions page
The table of transactions is interactive. That is, there’s an Action column at the end of each row. Click the down arrow next to any of the activity listed there, and you’ll see a menu of options. Depending on the status of each, these options include commands like Receive payment, Send reminder, Print packing slip, Send, and Void.
Running Reports
The Sales Transactions page provides more of your receivables nuts and bolts than the Business overview screen does. But to get the most in-depth, customizable, comprehensive view of who owes you, you’ll need to run reports. Click Reports in the toolbar and scroll down to Who owes you.
There are three columns here. You’ll land on Standard, which is a complete list of all of the pre-formatted reports that QuickBooks Online offers. Click Custom reports to see the reports you’ve customized and saved. Management reports opens a list of three reports that can be viewed by a variety of date ranges: Company Overview, Sales Performance, and Expenses Performance. You can view, edit, and send these, as well as export them as PDF and Microsoft Word files.
There are five reports listed under Who owes you that you should be creating on a regular basis. How regularly? That depends on the size of your business. The greater your sales volume, the more frequently you should run them.
When you select A/R Aging Summary, you’ll see at a glance which customers have current balances and those that are 1-30, 31-60, 61-90, and 91+ days past due. A few customization options appear at the top, like Report period, Aging method, and Days per aging period. To really zero in on the precise data set you want, click Customize. The panel that slides out from the right contains option in several areas: General, Rows/Columns, Aging, Filter (by customer), and Header/Footer.
QuickBooks Online helps you target the data set that you want.
There are four other reports that can help you track your receivables:
Open Invoices displays a list of invoices that still contain a balance.
Unbilled Time tells you about any billable time that hasn’t been invoiced.
Unbilled Charges lists billable charges that haven’t been invoice.
Customer Balance Summary simply provides all open balances for you customers.
These are all very simple reports that you shouldn’t have any trouble customizing and running. They can give you a complete picture of where your receivables stand. But there are other reports that will require our help. These are standard financial reports that should be created monthly or quarterly, including Statement of Cash Flows, Profit and Loss, and Balance Sheet. You’ll need these critical financial statements if, for example, you’re applying for a loan or trying to attract investors. Please let us know if you want us to run and analyze these so you can get a detailed, comprehensive view of your financial health.
Does your business have cash flow issues? We can walk you through the QuickBooks Online tools that help identify them.
Sign up for our newsletter.
Each month, we will send you a roundup of our latest blog content covering the tax and bookkeeping tips & insights you need to know.
We care about the protection of your data.
Junglebooks Affiliate Program
Why Partner with Us?
With years of experience and a team of certified professionals, we deliver exceptional results to our clients.
-
Industry-Leading Expertise
-
Our firm is a leader in the accounting industry, providing comprehensive services that include tax preparation, bookkeeping, financial planning, and business consulting. With years of experience and a team of certified professionals, we deliver exceptional results to our clients.
-
Attractive Commissions
-
We value our affiliates and offer competitive commission rates for every client you refer who signs up for our services. The more clients you refer, the more you earn.
-
Comprehensive Support
-
We provide our affiliates with all the resources needed to succeed, including marketing materials, dedicated support, and regular updates on our services. You’ll have everything you need to effectively promote our firm and earn commissions.
-
Trusted Reputation
-
Our firm has built a solid reputation for excellence and trustworthiness. When you refer clients to us, you can be confident that they will receive the highest level of service and satisfaction.
Frequently Asked Questions
-
This firm prepares tax returns for individuals, partnerships, corporations, estates, trusts, and any entities with tax-reporting requirements. Our firm’s seasoned professionals are experts in all areas of taxation including:
- Individual Returns
- Payroll Tax Issues
- Business Returns
- Sales Tax Returns
- Rental Income Returns
- Business Consultation
- Expatriate Returns
- Fiduciary & Estate Returns
- Corporation Returns
- Bookkeeping
- Partnership Returns
- LLC Returns
-
Our firm offers a full range of planning services including, but not limited to:
- Individual Tax Planning
- Business Tax Planning
- Business Organization
- Rental Properties
- Foreclosures and Repossessions
- Retirement
- Investments
- Sales and Exchanges
- Pension Plans
- Education Planning
- Finance & Refinance Planning
- Home Purchase and Sale Planning
-
We are here for you twelve months a year, not just during tax season. Whether you have a simple tax question, need advice on the tax implications of a business decision, or want clarification on a government notice, feel free to give us a call.
-
We maintain a policy of the strictest confidence concerning our clients’ affairs. You can rest assured that no one will learn about your business or tax status – even relatives, associates or friends who might have referred you to us.