Home For accounting professionals General accounting discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Best way to deal with a contra in sage IA?

Sarah-LouSarah-Lou Well-KnownRegistered Posts: 141
I have just set up a client on sage, they only wanted to pay for Instant Accounts and hence are missing a few features - one of them being the contra wizard.

How is the best way to deal with this manually? Any ideas?

Thank you



  • JanJan Experienced Mentor Registered Posts: 654
    Having never used any of the wizards, what are you wanting to do exactly?
  • Sarah-LouSarah-Lou Well-Known Registered Posts: 141
    I realised last night in bed I should have been slightly more specific!!!

    I have a supplier who my client owes money to and he is also a customer who owes money to them (albeit a small amount). Rather than him sending in what he owes and them sending him all they owe they want to show it contra'd against each other and on sage without a wizard i'm not entirely sure how to do this.

    Thank you!

  • MonsoonMonsoon Font Of All Knowledge FMAAT, AAT Licensed Accountant Posts: 4,071
    Post a bank-supplier payment and a bank-customer reciept for the same amount and call both their refs CONTRA. The 2 amounts cancel amount on the bank rec and you get the desired result in the ledgers. I.e. The balance difference.
  • JanJan Experienced Mentor Registered Posts: 654
    Beat me to it!
  • totleybladetotleyblade Feels At Home Registered Posts: 48
    If this is going to happen regularily it may be as easy to create a dummy 'contra' bank account to process the supplier payment and customer receipt. Same difference but it keeps your bank rec clear and, as its balance should always be zero, it's easy to spot an error.
  • Sarah-LouSarah-Lou Well-Known Registered Posts: 141
    Thank you. I did set up a bank account as there will be a few of these coming up.
  • AK002AK002 Font Of All Knowledge Registered Posts: 2,492
    That or credit notes to some nominal account, suspense or whatever.
Sign In or Register to comment.