Sales Tax Due Report (Canada, Australia)

The Sales Tax Due (Canada, Australia) report displays all Accounts Receivable and Accounts Payable transactions associated to a particular tax code (Administration > Reports > Accounting > Accounts Payable > Sales Tax Due (Canada, Australia).

Transactions include Customer Invoices, Customer Payments, Vendor Invoices, Vendor Payments, and Vendor Debit Memos. The report can be used to determine how much tax has been paid to vendors versus how much tax has been received from customers. This report can be ran on the Cash or Accrual Basis.

If run on the Accrual Basis, the report will display tax payments and tax receipts based on the date the transaction was invoiced. This output option only displays invoices,
If run on the Cash Basis, the report will display tax payments and tax receipts based on the date the transaction was paid. This output option only displays payments.

This report only appears if the logged in store country is Canada or Australia.

Tax Authorities

All Tax Authorities
Specific Tax Authority

Filtering by specific tax codes or authorities will eliminate AP Inventory Invoices from the output.

Output to

ACCRUAL BASIS

Report – Summary By Tax Authority: Displays total tax collected and tax paid on AR and AP Invoices grouped by Tax Authority. Information includes total Sale Value, Purchase Value, Tax Collected, and Tax Paid per Tax Authority.
Report – By Tax Code, By Tax Authority, By Store: Displays individual AR and AP invoices grouped by posting date, customer (AR) or vendor (AP), and transaction type. Information includes Invoice Number, Sale Value, Purchase Value, Tax Collected, and Tax Paid. Total tax collected and paid difference listed by Store, by Tax Code.
Directly to Excel: Exports the following information into an Excel spreadsheet: Sales Tax, Tax Authority, Store, Who, Transaction Type, Post Date, Transaction Number, Total, Sale Value, Purchase Value, Tax Collected, Tax Paid
Do Not Display Report Filters: Option to exclude report filters from displaying on the report header.

CASH BASIS

Report – Summary By Tax Authority: Displays total tax collected and tax paid on payments applied to AR and AP Invoices grouped by Tax Authority. Information includes total Sale Value, Purchase Value, Tax Collected, and Tax Paid per Tax Authority.
Report – By Tax Code, By Tax Authority, By Store: Displays individual payments applied to AR and AP invoices grouped by posting date, customer (AR) or vendor (AP), and transaction type. Information includes Payment ID Number, Credit Memo Number, Invoice Payment was applied to, Sale Value, Purchase Value, Tax Collected, and Tax Paid. Total tax collected and paid difference listed by Store, by Tax Code.
Directly to Excel: Exports the following information into an Excel spreadsheet: Sales Tax, Tax Authority, Store, Apply Date, Payment Type, Payment Transaction Number, Payment Total, Applied Transaction Number, Applied Total, Sale Value, Purchased Value, Tax Collected, Tax Paid, and Who.
Do Not Display Report Filters: Option to exclude report filters from displaying on the report header.

Security Permissions Required

Category	Function
Administration – Reports	Can Access Reports Tree Branch
Administration – Reports	Can Access Reports - Accounting