Index to Reports: Sales Tab
For each customer, this report displays the customer’s current balance followed by a list of their open sales with the amount due in the appropriate aging column.
Report Tip:
Use this as a “dunning report.” It shows every open invoice and notes the customer’s name and phone number. Don’t be shy about calling up a late payer. In a small business cash flow is sometimes more important than paper profits.
In the Report Filters window, check Separate Pages so each customer is on their own page. This gives you room to jot down notes about your contact experience at the bottom of the page. Or, if you are in front of the Accounting Plus screen while calling, use the customer’s contact log to make your notes.
Aged Receivables [Detail]
12/31/00
Name |
ID# |
Date |
Total Due |
0-30 |
31 - 60 |
61 - 90 |
90+ |
________________________________________________________________________________________ | |||||||
Acme Sales Inc. |
ASI322 |
||||||
Marvin Acme |
|||||||
515-555-1919 |
|||||||
C.O.D. |
|||||||
00000001 |
10/9/00 |
$6,000.00 |
$6,000.00 | ||||
00000004 |
10/9/00 |
$5,752.02 |
$5,752.02 | ||||
00000008 |
12/2/00 |
$1,802.62 |
$1,802.62 |
||||
00000006 |
12/11/00 |
($464.31) |
_________ |
($464.31) |
|
| |
Total: |
$13,090.33 |
$1,802.62 |
($464.31) |
$0.00 |
$11,752.02 | ||
________________________________________________________________________________________ | |||||||
Boffo Products |
BP233 |
||||||
Joseph Boffo |
|||||||
902-555-8777 |
|||||||
C.O.D. |
|||||||
00000002 |
11/11/00 |
$7,500.00 |
$7,500.00 |
||||
00000005 |
11/11/00 |
$258.75 |
$258.75 |
||||
00000009 |
12/2/00 |
$1,660.70 |
$1,660.70 |
|
|
| |
Total: |
$9,419.45 |
$1,660.70 |
$7,758.75 |
$0.00 |
$0.00 | ||
________________________________________________________________________________________ | |||||||
Widgets by Smith |
WS1002 |
||||||
604-555-4958 |
|||||||
C.O.D. |
|||||||
00000007 |
11/11/00 |
$1,000.00 |
$1,000.00 |
||||
00000003 |
12/1/00 |
$9,500.00 |
$9,500.00 |
||||
00000010 |
12/2/00 |
$1,955.00 |
$1,955.00 |
||||
00000011 |
12/2/00 |
$2,300.00 |
$2,300.00 |
|
|
| |
Total: |
$14,755.00 |
$13,755.00 |
$1,000.00 |
$0.00 |
$0.00 | ||
________________________________________________________________________________________ | |||||||
Grand Total: |
$37,264.78 |
$17,218.32 |
$8,294.44 |
$0.00 |
$11,752.02 | ||
Aging Percent: |
46.2% |
22.3% |
0.0% |
31.5% |