Can this be done in sage? Just doing a year end check for someone who does their accounts on sage and there are some with a mixture of different expenses. They have been listed under one nominal but they should have been split. Also now it is under one nominal can I split, looking at the corrections panel I can only change it to a different nominal, not 2 or 3 different nominals.
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
Cheers Mark, thought that would be the case. What about when you're logging the invoice? In VT+ I can enter the full amount then break it down to as many expense categories as I want, simply by entering an amount on the first line, which then leaves the remaining balance underneath ad finitum.
Looking at sage you enter the internal reference, external reference, nominal then amount, there doesn't seem to be any option to break it down further.
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
You break it down by entering 1 line on the 'batch invoice' process for each line that you want the invoice split into
So you copy the supplier ref, date etc on each line then enter the relevant nominal code for each item and split the net & vat out
When entering items such as this, after entering the 1st line and I am on the 2nd line I will use the F6 option which copies the line above into the line you are on
Once you have completed entering the data and posted it, it will appear as 1 item on the supplier ledger
Hi John
I agree with Mark. You can actually do the same with Bank payments/receipts too - the key with both is how you key something in the 'reference' field in sage.
Eg if in the batch invoice screen - if you use the same supplier invoice number on each line, you can put whatever you want in the ex ref and details boxes and it will appear as one item on the supplier account as Mark says. Same with Bank payments, but if you change it then it will come up as a lone on its own Eg with Bank payments - you may have several charges - if you enter all of the as 'chg' - then when you come to do your Bank rec all the items will be lumped as one, so instead key each with a slightly different ref eg chg/CHG/Charge/ChG then they will come up as separate items in the Bank rec.
The reason I mention the Bank side is - you may wish to split the item to different nominals and you can. Just not in the corrections screen once its been keyed. Would love to see this in future updates. But journals is your only option now.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
I could see that you could just enter each nominal on a separate line but I thought it would show up as 3 separate items in the supplier screen, so it's good to know it'll only show up as one item if done in the way you both describe.
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.
