Clean It Up

UK General Cleaning Forum => General Cleaning Forum => Topic started by: Mrs Nicholls on January 29, 2008, 12:12:54 pm

Title: supplier statement
Post by: Mrs Nicholls on January 29, 2008, 12:12:54 pm

Hi

I have been asked to provide a statement for one of my larger customers, as they are updating credit control accounts.

Thay are asking for a current statement or aging report for accounts held with them.

to include open invoices, debit notes credit notes and cash on account.
(They only have 1 invoice open at the moment, everything else is paid up)

How do  i lay this out? i dont think ive ever seen one, the statements i send out are different to domestic customers, these are commercial.

Can anyone give me some tips on the layout please?

Mant Thanks
Lisa

Title: Re: supplier statement
Post by: Fox on January 29, 2008, 06:00:16 pm

Lisa just a basic layout like below is fine, use a table or spread sheet.


Customer Name


Statement  09/01/2008


Date   Invoice No         Amount                Paid to Date   Balance
01/11/07   1559           1145.62                  0.00                   1145.62
15/11/07   1601           21.68                  0.00                   1167.30
01/12/07   1632           916.50                  0.00                   2083.80
01/12/07   1633           540.50                  0.00                   2624.30
01/12/07   1642 Credit   -540.50                    540.50                   2083.80
14/12/07   1661           15.86                  0.00                   2099.66
21/12/07   1691           28.73                  0.00                   2128.39
01/01/08   1686           916.48                   0.00                   3044.87
07/01/08   1712           15.86                  0.00                   3060.73
08/01/08   1714          13.04                  0.00                   3073.77
            
            



Total Due to date   2083.80   (obviously you would line it up better!  ;D)
   


The total due would be on your terms -  this one is 30 day term, you could do an aged system where the total is stating how much is 3 months +  2 months + 1 month + current month but really there is no need to complicate matters.  Or like me get a system that does it for you!

Fox
   

Title: Re: supplier statement
Post by: Mrs Nicholls on January 29, 2008, 10:44:05 pm

Hi Fox


Thank you very much for your reply, when they ask for these things do they usually mean this tax year? perhaps they are getting ready for 31st March.
It doesnt specify in the letter.

Thanks
Lisa

Title: Re: supplier statement
Post by: Fox on January 30, 2008, 07:45:04 am

Hi Lisa

This is a statement of accounts that are ongoing, some customers prefer to receive statements on a monthly basis for their purchase ledger payments, it's usually when they have alot of ongoing accounts.  I would send a statement out at the beginning or end of each month depending on how you invoice.

Fox