|
An Aged Debtors Listing Report and how to understand how it can do much more than tell you who owes you money |
|
|
Written by Nilsson Denver
|
|
Tuesday, 23 September 2008 05:01 |
|
An Aged Debtors Report has many titles, Aged Customers Report, Aged Outstanding Invoices Report, Accounts Receivable report and other name combinations. What it is, is a list of who owes your business money and how old the unpaid invoices are. If this is September, it may show you the amount you owe each customer for August, July, June and going back further if necessary. It can also list each individual unpaid invoice. Here is an example of an Aged Debtors Report. Aged Debtors Report at 31st August Supplier | Total | August | July | June | May | April + | App Systems | 21,000 | 10,000 | 9,000 | 2,000 | 0 | 0 | Bills Machines | 500 | 0 | 0 | 0 | 500 | 0 | Double IT | 19,000 | 6,000 | 6,000 | 6,000 | 1,000 | 0 | JJ Computers | 4,500 | 1,500 | 0 | 0 | 0 | 3,000 | QT Systems | 10,100 | 5,000 | 5,000 | 0 | 0 | 100 | Tooling Co. | -2,500 | -2,500 | 0 | 0 | 0 | 0 | Wells Mech | 3,000 | 1,500 | 1,500 | 0 | 0 | 0 | | | | | | | | Totals | 55,600 | 21,500 | 21,500 | 8,000 | 1,500 | 3,100 |
What useful information does this report give us 1. How much in total you are owed by customers 2. How old is the debt you are owed. In this case there are unpaid transactions going back to April 3. How much each customer owes you 4. How old the debt is for each individual customer |
|
Last Updated on Sunday, 21 September 2008 21:07 |
|
Read the full article here
|
|
An Aged Creditors Listing Report and the benefits of printing one out every month |
|
|
Written by Nilsson Denver
|
|
Tuesday, 16 September 2008 05:01 |
An Aged Creditors Report can be called many things, Aged Suppliers Report, Aged Outstanding Invoices Report and other name combinations. What it is, is a list of who your business owes money to and how old the unpaid invoices are. If this is September, it may show you the amount you owe each supplier for August, July, June and going back further if necessary. It can also list each individual unpaid invoice. Here is an example of an aged creditors report. Aged Creditors Report at 31st August Supplier | Total | August | July | June | May | April + | | Ace Products | 21,000 | 10,000 | 9,000 | 2,000 | 0 | 0 | Elec Co. | 500 | 0 | 500 | 0 | 0 | 0 | Fixit Services | 4,000 | 0 | 1,000 | 1,000 | 1,000 | 1,000 | | JJ Computers | -5,000 | 0 | -5,000 | 0 | 0 | 0 | Rays Days | 100 | 0 | 0 | 0 | 0 | 100 | Rialto Tools | 2,500 | 2,500 | 0 | 0 | 0 | 0 | Sugar Search | 3,000 | 1,500 | 1,500 | 0 | 0 | 0 | | | | | | | | | Totals | 26,100 | 14,000 | 7,000 | 3,000 | 1,000 | 1,100 | What useful information does this report give us |
|
Last Updated on Tuesday, 16 September 2008 08:16 |
|
Read more...
|
|
How to deal with bad debts in a computerised accounts system to minimise the loss to your business |
|
|
Written by Nilsson Denver
|
|
Tuesday, 09 September 2008 05:01 |
|
Depending on how you create sales invoices in your accounts system, this will determine how you record bad debts in your accounts system. There are two main methods of Sales Invoicing in an accounts system. 1. Sales Invoicing with Stock Items on the Invoice 2. Sales invoicing entered using a nominal code only (also known as batch invoicing) Method1.
You use stock codes on your sales invoices your invoice may look like this Stock Code | Description | Qty | Price | Total | 23-AGF-001 | AGF Compressor | 2 | 100.00 | 200.00 | This is one line from your Sales Invoice and you will send the invoice to your customer with this detail on it. The VAT will be calculated automatically on the invoice Method 2. With non stock code or batch invoicing, usually you have sent a handwritten docket with the same details as a computerised stock sales invoice, but when you record the invoice in your accounts system you may enter something like the following; You use nominal codes using batch entry Nominal Code | Nominal Code Description | Net | Vat | Gross | 1001 | Sales of Compressors | 200.00 | 42.00 | 242.00 | In this case you record the sales nominal code and not any stock codes. How to record bad debts
With both methods you will issue a credit note to claim back the VAT you paid out and reduce the sales you made. If you were successful and got back some of the stock you sold to the customer, you would issue a credit note for the goods you got back to the customer. |
|
Last Updated on Tuesday, 09 September 2008 07:28 |
|
Read more...
|
|
Customer accounts, set them up as open Item or balance forward, what this means and which do you use |
|
|
Written by Nilsson Denver
|
|
Tuesday, 02 September 2008 05:01 |
When you send a customer a statement that is "Open Item", this means that when you print out a customers statement, every invoice that is unpaid will be shown on the statement. Each unpaid item will be listed in date sequence. Customer Statement at 28th Feb 2008 (Open Item) Date | Transaction | Debit | Credit | Total | 5 Jan 2008 | Invoice 101 | 150.00 | | 150.00 | 20 Jan 2008 | Invoice 135 | 250.00 | | 400.00 | 01 Feb 2008 | Invoice 159 | 210.00 | | 610.00 | 25 Feb 2008 | Invoice 178 | 199.90 | | 809.90 | When you send a customer a statement that is "Balance Forward", this means that when you print out a statement, all the unpaid invoices, credit notes, unallocated payments from the previous months are totalled together and this amount is shown as the opening balance on this months statement Customer Statement at 28th Feb 2008 (Balance forward) Date | Transaction | Debit | Credit | Total | 1 Feb 2008 | Balance B/F | 400.00 | | 400.00 | 1 Feb 2008 | Invoice 159 | 210.00 | | 610.00 | 25 Feb 2008 | Invoice 178 | 199.90 | | 809.90 | The advantage of a Balance Forward customer statement is that it is shorter. There are fewer transactions to print out as all the previous months transactions appear as one total in the Balance B/F amount.
|
|
Last Updated on Monday, 01 September 2008 16:38 |
|
Read more...
|
|
|