Payable with Tax report

Hi Vivek123,

The Payables with Tax report shows what you owe suppliers including GST, while the Payables Reconciliation report Compares the total balance of your unpaid bills to the balance of your linked payables category. These two reports might not match due to a few common reasons:

• The Payables with Tax report includes GST while the Reconciliation report doesn't.
• Manual journal entries posted directly to the Trade Creditors account won't reflect in supplier cards.
• Changes in the linked payables account setup can cause mismatch.
• Timing differences, like future-dated transactions or unrecorded supplier credits.

To fix this, below are the workarounds:

• Go to Setup > Linked Accounts > Purchases and check your Accounts Payable setup.
• Use Find Transactions on your Trade Creditors account to look for manual entries. 
• Check if the difference is simply the GST amount.

Lastly, if you're opening the Payables with Tax report in the AccountRight browser and shows an out-of-balance, make sure to export the said report from the AccountRight desktop version. If you're still having issues, make sure to reach out to our team on Live Chat via our virtual assistant, MOCA, or by submitting a support case via MyAccount.

Cheers,

Doreen

Thanks Doreen for your inputs.

A quick clarification! You say that the Payables with Tax report includes GST. Why do you say the Payables Reconciliation report doesn't  include GST. Don't the dues to suppliers which is reflected in the Payables Reconciliation report include the GST?

What is the purpose of the Payables with Tax report? Isn't the Payables Reconciliation report to check whether it balances with the Linked Payables account good enough?

Please let me know. Thanks

Vivek

Hi Vivek123,

The "Payables with Tax" report shows your payables and the GST amounts together, making tax reporting and reconciliation easier. Meanwhile, the "Payables Reconciliation" report is all about matching up supplier balances with account balances in your payable accounts, but it doesn't provide GST details. For more info, check out the sales reports description on this link. 

Cheers,

Princess

Thanks Princess for your reply.

If this is the case why will the balance amount in the payables reconciliation for a supplier not match with the balance shown in the Payables with Tax report for the same supplier.

Cheers Vivek

Hi Vivek123, 

That's a great follow-up question. The discrepancy between the Payables Reconciliation report and the Payables with Tax report comes down to how each handles data. The Reconciliation report shows the outstanding balance as of a specific date, while the Payables with Tax report includes tax components and any open transactions, even if they are future-dated or not fully posted.

The reports can reflect different balances because they filter transactions differently, especially when tax codes or future-dated entries are involved. To reconcile these reports, ensure the date ranges are aligned and look for any partially applied or future-dated transactions. If they still don't match up, it might be best to seek help from online assistance.

Regards,

Genreve