Customer Account Statement Template for Excel

How to use this spreadsheet?

Customizing template to your business needs.

Update all necessary fields with your company information.

1. Change all values in the square brackets [...] - values applicable to your company need to be replaced with your company information.

2. Company Name - Change it to the name of your company, this will automatically change "Make all cheques payable to [Your Company Name]" field below.

3. Company Logo - insert your company logo by going to your menu Insert > Picture > From File... (only available in unlocked version).

4. Bank Account - Change your company business account number to the account that you want to receive your electronic payments.

5. Cheque Payments - this field is automated and will therefore change automatically once you change the name of the company at the top of the statement. If the cheque needs to be payable to any other than your company name, you can manually override the formula in this field, but only in unlocked version.

6. Account Managers Name - Change it to the name of the person responsible, usually it will be your accountant or account manager.

8. Contact Information - Change your contact information (eg. Phone, Fax, e-mail, postal address).

9. Saving Template - Save the updated document as .xlt file in preferred folder on your computer (Eg. My Documents > Customer Statements).

Preparing the Statement for your customers.

Update all necessary fields with your customer information.

Date - the date will change to today's date automatically each time you open your document, but you can manually override the formula in this field to show the date of issue.

Statement Number - assign the number to your statement that must be different for each new statement that you send, you can start by using 00001 for the first statement and follow up with your next one (eg. first statement - 00001, second - 00002).

Customer ID - you can use it for frequent customers or the customers that have a company account with you for easy identification.

Payment Due Date - the date when the payment is due.

Date, Invoice # and Description - the summary of all monthly activities on the account.

Printing and sending your Statement.

You can simply print your Statement on your standard printer on A4 size paper and send it by standard post service, but the much quicker way is to convert it to a PDF and e-mail it to your customers.