Blogger
Share this content
0
7
9387

CUSTOMER WRITE-OFFS ON SAGE 50

When using the Customer Write-off Wizard for a bad debt on Sage Line 50 (2011), how is the output tax on the original sales invoice reclaimed on the VAT Return? When I have completed the Write-off Wizard, I look in the financials and see an SC transaction with the whole amount inclusive of the VAT element in the Net Amount column.

So how does the VAT return bring in the output VAT to be reclaimed on the bad debt, or is there something else that I have to do for this?

Replies

Please login or register to join the discussion.

avatar
08th Aug 2012 09:23

Write Offs

The wizard takes no account of VAT, as you've found it posts an SC for the gross amount with a T9 tax code.  The simplest thing is not to use the wizard at all and just post the SC manually with the relevant amounts then go to Bank -> Customer and allocate the SC to the relevant SI.

John

Thanks (1)
avatar
By Old Greying Accountant
08th Aug 2012 10:28

This is my biggest aggravation with SAGE ...

... why can't they let you choose where to post write offs to in the wizards, and whether to split out VAT.

But, the biggest bugbear is trying to post refunds on the ledgers that don't fit SAGE's verytight criteria and having to work out convulted work arounds!

Thanks (1)
avatar
08th Aug 2012 11:01

Write Offs

Agree totally with John. His method is the correct one, remembering to use nominal 8100 for the write off

Never use the write offs wizard for anything other than small balances less than £1

Old Greying Accountant, have you tried using the Refund buttons at the bottom of the Tasks menus in Customers and Suppliers? These work perfectly for both Standard and Cash Accounting VAT. (if you are cash accounting it gives you the option to change the VAT code)

If the credit/overpayment is in the list that comes up after you have specified the account for the exact amount of the refund, then just Refund in full on the item and Sage will automatically allocate the refund against the credit. If the amount is not exact then just enter all the details at the top and then save and allocate through the bank as John explains above

This option has been in Sage since at least V13 (2007)

Karen

 

Thanks (2)
avatar
By Old Greying Accountant
08th Aug 2012 11:52

Trouble is ...

... there are many many people on version 11 still, as it does 99% of what they want and don't want to pay hundreds of pounds to upgrade for the extra 1%.

Thanks (1)
avatar
21st Aug 2012 14:40

VERSION 11

True enough - they always want to sell you the next version but for the expenses it is just not worth it.

Thanks (0)
avatar
08th Aug 2012 19:10

Hi 

Hi 

Old Greying Accountant.   I do understand what you mean by  upgrading from one year to another,  But I might be wrong in my understanding,  You mentioned that many accountants are on version 11 do you mean 2011 or version 11 

If it is Version 11 then this would have been released in the year 2005 there has been 8 upgrades since then including Sage L50 2013 and that is over 7 years ago.  There has been far more than a 1% improvement.   The refunds you mention as far as I believe Witch Doctor in my memory was before that , but happy to be corrected , as it was there in the DOS version, disappeared when Sage went all Windows and Mouse and less about using your keyboard. The refunds by only entering the amount then  came back again and disappeared and as you say have been there for good since V13 2007.  Mind you Sage are not the only culprits for all the windows .  (Ah the memories) 

For me Sage L50 2012 was probably the biggest leap forwards and lot of the issues people have to not happen in Line50 2012 .   

I have just down  loaded the New Version 2013 as I was really interested to see if the feedback was taken by Sage as I was one of the people who was testing it out at Newcastle. The reports have change dramatically and are far more drillable and there is such a huge improvement that the feedback from some of us may lose work because it was so much easier 

 

Kind Regards Sarah Douglas Douglas Accountancy and Bookkeeping Services Glasgow 

Thanks (0)
avatar
21st Aug 2012 14:41

VERSION 11

Yes I mean 2011 - actually version 17.

Thanks (0)