Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
August 2022
August 2022
Hi Community,
A new business of ours uses Guestpoint as its accomodation software. It produces an export for the income and payment recognition in the form of a general journal entry. It is based on the old type of fields i.e. debit ex gst debit inc gst etc, so i have converted it to the new format with the {} as the first line in the txt file.
However, we keep getting error -19 unbalanced transaction, even after double and triple checking the amounts in excel with the amounts 100% matching to two decimal places (rounded).
It will import successfully as a transaction journal entry but this does not include tax codes and tax amounts. Are the tax amounts throwing this out? We've made sure the entries have the "X" in the inclusive column where necessary but Accountright just does not want to import it.
Files attached for reference.
Solved! Go to Solution.
August 2022
August 2022
Hi @CA_EGH , welcome to the forum. My guess is that the import process in the new AccountRight requires the Amount column to be the net amount, regardless of what the GST-inclusive flag says (this only affects the display of the transaction in AR).
In your file the Amount column is the inclusive amount, which used to be acceptable to v19 imports.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
September 2022
September 2022
Hi Mike,
Thanks for your response.
Uploading as exclusive amount regardless of the gst-inclusive flag worked.
Solution verified.
Regards
Craig Archbold
12
|
880
|
|||
3
|
438
|
|||
7
|
400
|
|||
4
|
721
|
|||
1
|
569
|