anyone good with sage? trying to improve a report for due invoices

unwashed potato!

unwashed potato!

unwashed potato!

Soldato
Joined
12 Feb 2006
Posts
17,710
Location
Surrey
we used sage 50 accounts essentials. our accounts are the most super sexiest cleanest you could ever imagine for a company to have, however there is one small thing i wish to sort out and that is making it so some invoices are not shown on the customer and supplier invoices due reports.

1 example of the style i'd like removed is a customer who pays us to use our bins.

we created 1 single invoice at the beginning of the year for the full total of £120, and he pays us £10 each month to slowly pay off that invoice. there's no need for this invoice to be shown on our reports as it's not really due. i've set the due date 1 year time, the payment settlement etc all to 1 year away, but when i select 'customer invoices due' report, there it is messing up the report.

anyone know how i'd change this so that this sort of invoice doesn't show? perhaps we've done it wrong by creating an invoice this way, so would be interested if anyone can suggest a better way to do this.

it may sound silly, but theres a few others like this, and now i have the app on my phone which gives a nice overview of my accounts, it's annoying to always see say 8 sales overdue, when in reality it's just 3.

thanks
 
I use Sage as well as Quickbooks....and yes, I can understand why that would be annoying, as I had something similar with inter-co charges between two linked businesses I run

As the goods didn't need to particularly be paid for, the account would build up and distort the reports to how much was owed / due

I'm not sure on Sage what filter you could put in to automatically get it to ignore those invoices though...

What I ended up doing on quickbooks was move the amount owed (on one company) and the amount due (from the other company) to the balance sheet (long term inter-co asset/liabilities) and then post any payments to the Bal Sheet - that way it's off all Sales/Purchase overdue reports

Or it would be easier to just invoice him monthly!
 
Fairly sure the answer is no said:
example of the style i'd like removed is a customer who pays us to use our bins.

we created 1 single invoice at the beginning of the year for the full total of £120, and he pays us £10 each month to slowly pay off that invoice. there's no need for this invoice to be shown on our reports as it's not really due. i've set the due date 1 year time, the payment settlement etc all to 1 year away, but when i select 'customer invoices due' report, there it is messing up the report.
Click to expand...

If you invoiced them the full amount, then the full amount is owed and should show up on the invoices due report. You probably should be going the route of a recurring invoice for £10, or else accept the fact the whole amount will show up. There is also the issue of tax, since vat is calculated from the point of invoice in standard accounting.
 
Have you not got a support contract with Sage? ringing them would probably get this sorted for you in a few minutes.
 
Just raise the invoice at the end of the year instead of at the beginning, and confirm with the client that that's how you'll be invoicing in future - he should continue to pay monthly.

You'll be left with unallocated receipts, but I doubt you'll be looking at that report in the same way as the debtors one.
 
cheesyboy said:
Just raise the invoice at the end of the year instead of at the beginning, and confirm with the client that that's how you'll be invoicing in future - he should continue to pay monthly.

You'll be left with unallocated receipts, but I doubt you'll be looking at that report in the same way as the debtors one.
Click to expand...

good shout. will do that.
 
You must log in or register to reply here.
Back
Top Bottom