By now we’re sure that you have run one of QuickBooks Online’s accounts receivable reports, A/R Aging Summary, to see a list of past due invoice payments; however, there are many other reports. Familiarizing yourself with them can help you throughout the year, not just in January when you’re trying to put your financials back in order.
To see the whole list, click on Reports in the left vertical toolbar. If the All Reports link is not underlined, click on it. Then click Manage Accounts Receivable.
Figure 1: This is a partial list of the accounts receivable reports offered in QuickBooks Online.
You probably don’t need to run every report in this group frequently, but there are some that can provide the insight you need when you’re trying to tie up loose ends and prepare for the rest of the year. They include:
- A/R Aging Detail. The A/R Aging Summary only displays totals for each customer with a past due status. The report divides these into 30-day increments, so you can see how much each customer owes currently, 1-30 days overdue, 31-60 days overdue, etc. A/R Aging Detail divides the report into those same time periods, but it displays every corresponding invoice for every customer, its original due date, amount, and open balance.
- Customer Balance Detail. This report doesn’t break out past-due invoices by 30-day increments. It groups outstanding balances by customer. By quickly scanning the Due Dates and Open Balances, you can get a quick snapshot of each customer’s status. Are any payments due soon? Is there a high balance that needs to be addressed?
- Collections Report. You – or whoever handles collections for your company – should be running this report regularly. You can see which customers have past-due balances and by how many days, which individual invoices are represented, and the total amount owed.
Contacting customers in an attempt to collect past-due payments is probably not your favorite thing to do. Let us know if you want help customizing QBO and using its other tools to minimize late remittances.
Seeing the Data You Need
QBO’s report templates are constructed to display the data that most business people want to see. You have tremendous control, though, over the columns that appear. Customization options on the site are quite generous.
Figure 2: QuickBooks Online offers countless options for the data that is displayed in its reports. We can help you work with these if you’re new to report customization.
Open the Customer Balance Detail report and click the Customize button in the upper left. There’s very little that you can’t modify in QBO reports. Click on each link in the left vertical navigation tool to get a sense of what’s possible.
If you alter the options in a report and think you’d like to run it again in the future with the same modifications but with refreshed data, click Save Customizations in the upper left after you’ve finished making your changes. Type a new name for this modified report in the field provided in the small window that opens. When you want to generate it again, go toAll Reports | My Custom Reports to find it.
We strongly encourage you to customize some of your routine reports. This kind of zeroing in on the exact set of data you want can help you evaluate your current financial status — and make better business decisions. Need help? We’re always a phone call away at 256-337-5200.
The “QB Bob” Team