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.