Separating QuickBooks Accounts Receivable by Divisions

How to Track QuickBooks Accounts Receivables by Divisions

A reader wants to know how to keep tabs on the aging and A/R data for wholesale customers separately from retail customers. He uses different QuickBooks transaction templates for each customer group and wants to have an efficient way to track A/R data. Classes don't work because balance sheet accounts don't have class-based reports.

The most efficient way to do this is to use two A/R accounts; one for wholesale and one for retail. QuickBooks lets you track invoice numbers by A/R account, so you can devise a numbering scheme that's specific to each type of customer (e.g. start the second A/R account with a six-digit invoice number).

You have to remember to select the right A/R account at the top of the QuickBooks Create Invoice transaction window, and you also have to select the right A/R account in the Receive Payments window (customer invoices won't show up unless the same A/R account is selected.

You could also use QuickBooks Customer Types to separate the customers, and then create memorized reports for all customer activities, based on the customer type.


Be Sociable, Share!

Comments are closed.