Issue importing invoices to Reckon Accounts Hosted

  • 1
  • Problem
  • Updated 2 weeks ago
I'm trying to import an invoice in Reckon Hosted. I'm getting the following message:
"The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount on the top of the form.". What am I doing wrong here?
Photo of Didier

Didier

  • 130 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,320 Points 20k badge 2x thumb
The split line amount should be -87.50 - this and the GST add up to the negative but same value as the AR amount of 96.25... basically all the numbers should equal zero.
Photo of Didier

Didier

  • 130 Points 100 badge 2x thumb
Thank you for your reply, Linda. Unfortunately that didn't work. I'm getting the same message. 
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,320 Points 20k badge 2x thumb
can you upload an image of the amended transaction please?
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,320 Points 20k badge 2x thumb
Also - I would usually expect the TRNSTYPE to be TAX INVOICE (with a space) - not INVOICE
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,320 Points 20k badge 2x thumb
I would also suggest removing the column EXTRA  and then removing the reference to AUTOSTAX - this may be affecting the import?
Photo of Didier

Didier

  • 130 Points 100 badge 2x thumb
Hi Linda, here is an image of amended transaction. I will give your suggestions another try and will let you know the outcome shortly. So frustrating spending hours fiddling with this and getting nowhere!
Photo of Didier

Didier

  • 130 Points 100 badge 2x thumb
Still no luck :(
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,228 Points 20k badge 2x thumb
You havent changed the amount from my very first reply - underneath where the TRNS line says 96.25 - it should say -87.50 on the SPL line - so that this amount plus the -8.75 GST adds up to the total positive value of 96.25 - making the whole transaction 0.
Photo of Didier

Didier

  • 130 Points 100 badge 2x thumb
Legend. Thanks very much, Linda! Reckon Help notes are not that clear and often confusing.
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,228 Points 20k badge 2x thumb
well done..  glad you got it working.  :)