 |
Customer Statement of Account
Template: Spreadsheet to Keep Up-to-Date Accounts Receivable
Records/Remind Customers of Payment Due
| Benefits: Do you extend
credit to your customers? If you do, two things are essential to
maintaining control of your receivables. First, you need to
maintain an accurate accounts receivable ledger for each
customer — in other words, an up-to-date record of each
customer's charges, payments, and balance due. Second, you also
need to be able to send an accurate monthly statement to every
customer who owes you money. |
| |
To help you accomplish both tasks, we have designed a
spreadsheet, contained in the attached file, that combines the
accounts receivable ledger and customer statement of account.
You can use it to keep track of charges and payments on each
customer's account and then, at the end of the month, send the
same form to your customers, reminding them of their balance
due.
|
| File Description: The
file contains a Microsoft Excel (version 4.0 and above)
spreadsheet template. Once you've downloaded the file, you must
copy it to your EXCEL\XLSTART directory in order to use it. |
| |
 Download
Now: Customer statement of account template |
| |
 |
For assistance on
downloading and saving a file, click here.
|
|
|
To return to main menu,
click here. |
|
| |
| Special Features:
|
|
Download this spreadsheet
template just once, and be able to use it to create a
statement of account for each of your customers.
|
|
|
Customize the statement to
meet your needs. Add or delete entries, move things
around, or modify the format of the statement any way
you like. |
|
|
Use this same template to
maintain accurate accounts receivable ledgers and as a
statement of account to send to each customer who owes
you money. |
|
|
|
