ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Template 9 - Statement of Account (https://www.excelbanter.com/excel-discussion-misc-queries/257172-excel-template-9-statement-account.html)

Bridget

Excel Template 9 - Statement of Account
 
We need to link the running balance on this template to a aging summary with
customer balance currently due. Are there any compatible templates such as
A/R Summary based on the balances in the Statement of Account template?

[Company Name] Statement Date: 2/23/2010
[Company Address] Date Due: [DATE DUE]
[City, ST ZIP Code]
[Phone]
STATEMENT OF ACCOUNT
[Customer Name]
[Address]
[City, State ZIP Code]

DATE DESCRIPTION CHARGES CREDITS ACCOUNT BALANCE
Balance brought forward $56.00
05/12/04 The Phone Company $500.00 $556.00
05/13/04 Woodgrove Bank $250.00 $306.00
05/14/04 City Power & Light $125.00 $431.00






All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com