Usually, a business will issue a statement of accounts to its customers at regular intervals, such as on monthly basis to show amounts still owed by its customers and the details.
We need to have a separate sheet to contain a structure of our statement of accounts.
Below is a sample structure:
A B C D E F G 1 2 OUR LETTERHEAD 2 CUSTOMER B 3 123 Jalan Lumba Lumba 4 KL 5 CUSTOMER B 6 TO 7 8 ABU DAUD 9 A21 10 JALAN 6 11 MANTIN 12 NEGRI 13 14 TOTAL 1,183,058.28 15 16 1 Date Inv No RM Status Open only 17 30 31 01-Jan-01 0 200,000.00 pd 18 248 279 11-Jan-01 0911-1023 332,356.74 pd 19 7 286 05-Feb-01 1005-1030 361,509.41 Open 361,509.41 20 9 295 06-Mar-01 1106-1039 474,081.73 Open 474,081.73 21 8 303 02-Apr-01 1202-1047 347,467.14 Open 347,467.14 22 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 23 24 25 Yours truly 26 27 signed 28 29 SALES MANAGER 30
188
No comments:
Post a Comment