For tax recovery purposes, some Canadian companies require the ability to track 50% of GST (Purchase) in one account, and 50% in another account.
As of the moment, the tax group function for Canada nexus is limited to including 2 types of tax codes only (GST/HST and PST).
As an alternate solution, users can create a transaction search to look specifically for purchase transactions impacting the GST and from there make some manual adjustments via a journal entry.
1. Navigate to Reports > Saved Searches > All Saved Searches > New > Transaction.
2. On the Criteria tab > Standard subtab, add the following filters:
Type = Bill
Memo = is GST
You can also add a filter for Date or Period to limit the results to a specific date/period range.
3. On the Results tab, mark the Show Totals box.
4. Still on the Results tab > Columns subtab, add the following fields:
Date
Number
Name
Memo
Amount
Formula (Currency) -to be renamed as %0% GST to be Adjusted ; Formula = {amount}/2
5. Rename the search and hit Save & Run.
No comments:
Post a Comment