You’re offline. This is a read only version of the page.
1,780
Hi!
I have problem with Tax Transaction Report with the option 'Exclude Voided Transactions'. Sometimes if I mark this options it tallies with GL and sometimes it won't tally, if I mark this option.
Any idea??
Regards,
Mohan
*This post is locked for comments
Hi Ian,
Thanks for giving some ideas. Let me try out and see whether I can fix this issue.
Regards,
Mohan
Hi, I am not aware of a known issue with this report, so the below is based on there not being one. Even if there was, you would need to invstigate the following first.
All things being equal, the report version that excludes voided transactions, should tie into your GL. However there are valid reasons why this might not be the case.
You could have posted a transaction in say, receivables of payables, and entered incorrect GL distributions for your Tax account in the GL. Therefore the transaction is included in the report, but not in the account in the GL you are reconciling to. Its Tax distribution got posted to another account. You could try creating a smartlist that lists the tax distribution of every transaction...and filtering it to where the GL account index is not equal to your tax GL account index.
There could be unposted GL transactions (created by transactions in the sub ledger - Receivables / Payables)..that need to be posted. Verify that everything is posted.
Does your payables and receivables balances agree to your GL accounts? You could have posted a transaction in a sub ledger and deleted the resultant GL journal that was created. Run the GL to RM / PM reconcile utility to identify diffrences between your sub ledgers and your GL...If these transactions had Tax on them, the tax distribution will also not have poste.
You could have voided a sub ledger transaction, and deleted the resultant GL journal. The above will also identify these.
There could be journals in your Tax GL account that did not origiate in a eithre payables or receivables...ie a GL transaction that posted to your Tax GL account.- This would not be included in the Tax report (unless it was Tax analysed, of course....what I am talking about here is a straighforward GL journal...debit one account, credit another). Do an enquiry on your Tax account in the GL, and filter it by transaction code....ie slect GJ to identify any general journals that might have been posted to the account.
Additionally, if you are trying to reconcile by date, you could have posted a transaction in a sub ledger using one date, and posted it in the GL using another date. If you run your report and include transactions based on document date and then compare that to the balance on the GL account at the same date...there could be a timing difference.
Hope this gives you some ideas on how to reconcile the two.
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (