QBO Receivable Reports

Using QBO Accounts Receivable Reports

With the holiday's and year-end over, you can turn your attention to catching up with your customers.

It would be nice if you could wrap up every accounting month or quarter or year neatly, with all of your transactions completed. All current bills and invoices would be paid, physical inventory amount would match the quantities in our records, and all purchase orders would be fulfilled.

Unfortunately, it usually doesn't work like that. Businesses and individuals get caught up in the flurry of activity that occurs every December, and work gets delayed.

It's a good idea to take stock of your accounts receivable in January. Most people are back in the office and ready to take on the new year's tasks.  Quickbooks online makes this catch-up work easier with it's group of related reports.

Numerous Templates

It is likely that at some point you have run on of the Quickbooks Onlines  accounts receivable reports, A/R Aging Summary, to see a list of past due invoice payments. But there are many other reports. Familiarizing yourself with them can help you throughout the year, not just in January when you are trying to put your financials back in order.

To see the whole list, click on Reports in the left vertical tool bar. If the ALL REPORTS line is not underlined, click on it.  Then click MANAGE ACCOUNTS RECEIVABLE.

fig1

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 QuickBooks Online and using its other tools to minimize late remittances.

Seeing the Data You Need

QuickBooks Online’s report templates are constructed to display the data that mostbusinesspeople want to see. You have tremendous control, though, over the columns thatappear. Customization options on the site are quite generous.

fig2 ar

Figure 2: QuickBooks Online offers countless options for the data that is displayed in its reports. We canhelp 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 QuickBooks Online 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 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 to All Reports | My Custom Reports to find it.

We strongly encourage you to customize at least some of your 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. Contact us today to set a time to help set everything up.

 

Bookmark the permalink.