Anonymous
Share this content
5

Sage Line 50 - Supplier Invoices

The best way to keep a steady P&L with Sage Line 50?????

Didn't find your answer?

Search AccountingWEB

Evening all,

So currently we close off our P&L each month and I'm going to use August as the last month end.

We currently recieve invoices a few weeks after the month end that will be dated for the closed months, 31/08 ect.(serious pet hate of mine just date it the day you send it but we won't get in to that.) These invoices have not been accrued so need to go in to the September P&L and unfortunately Sage doesn't have the option for me to put the date of the invoice and choose the reporting month. 

The way we have been getting around this is by journals for example:

Debit - Purchase control account 

Credit - purchase tax account

Credit - purchases expense 

And then we reverse this journal with a September date to ensure it makes Septembers P&L.

Is there an easier way for us to do this on Sage? 

 

Thanks 

Replies (5)

Please login or register to join the discussion.

Scalloway Castle
By scalloway
09th Sep 2019 19:39

This is a weakness of Sage. Once a period is closed that is it.

Thanks (1)
Replying to scalloway:
avatar
By sarah douglas
10th Sep 2019 11:18

Unfortunately once close sage Sage down it makes it difficult ,stop closing down the month end going forward . Just the the same as you can unlock Xero.

If someone invoices for work on the date they sent it and it is actually for a previous period I would have expected you to have done an accrual so your management accounts were right for the month you were presenting them.

Thanks (0)
avatar
By paulwakefield1
09th Sep 2019 19:48

If you take the year to date TB for the reporting month less previously reported year to date for the previous month, the management accounts will pick up earlier dated invoices in the reporting month. This is easy to set up in, say, Excel.

Thanks (1)
avatar
By Sandnickel
10th Sep 2019 07:01

Don't close the month off. If it's possible to stop this procedure then you won't have the issue, you can just report as per Paul's post.
I don't consider this a weakness, I do however think it's an unnecessary procedure in a smaller company.

Thanks (0)
avatar
By DouglasN
10th Sep 2019 10:45

Fully prepared for people to jump up and down at this suggestion. There is no indication from the OP about volume or value, but if its only a couple of hundred quid just post the invoice to sage dated 01/09/19.

And if it is any more than a couple of hundred, I would suggest getting better at knowing what the month end accruals should be (from delivery notes for example).

Also, I'm not a fan of journals to vat and creditors on sage, does this mean having to do a manual reconciliation of both at every month end? - yuck.

Thanks (0)
Share this content