Accounting & Bookkeeping · How-to guide

Use Tax Detail, Summary and Liability reports

Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on.

Follow this guide to review taxable transactions, totals by tax rate and the resulting tax payable or receivable position.

Audience: Finance and tax staffFeature: Tax reportsModule v1.4.5

Jump to steps

Where to goAccounting → Reports → Tax Detail / Tax Summary / Tax Liability

Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reports: View. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver.

What you’ll accomplish

Review taxable transactions, totals by tax rate and the resulting tax payable or receivable position. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping flow rather than a generic spreadsheet process.

How it works

The module exposes dedicated Tax Detail, Tax Summary and Tax Liability report actions and dedicated tax mapping settings.

Tax results depend on source tax lines and conversion completeness. A transaction posted directly to a tax account through a manual journal can affect the liability without appearing in source-detail expectations.

Have a qualified tax professional review regulatory treatment.

Follow these steps

Select the tax period.
Run Tax Detail and inspect exceptions.
Compare taxable sales with invoices and credit notes.
Compare purchase tax with expenses, bills and purchase invoices.
Run Tax Summary.
Run Tax Liability and reconcile to tax accounts in General Ledger.
Export the reviewed evidence for the tax process.

Settings to check

Tax DetailLists source lines and tax amounts.

Tax SummaryAggregates activity by tax rate or category.

Tax LiabilityShows the net tax position according to mapped entries.

PeriodMust match the filing or review period.

Sales and purchase sidesOutput and input tax should be distinguished.

MappingDetermines ledger classification.

Check it worked

After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits must balance and the accounts must match the approved mapping or manual selection.

Open the saved record and confirm its final status.
Review the source reference and every debit and credit line where ledger data was created.
Use the relevant register, ageing, reconciliation or report to verify the wider effect.

Common mistakes to avoid

Do not use the report as jurisdiction-specific advice.
Check zero, exempt and unusual rates.
Investigate missing tax mappings.
Respect filing-period close controls.
Use the least destructive correction available and record the reason for material changes.
Do not bypass a permission, approval or closed-period control by changing unrelated data.

Accounting and data safetyDeletion, reset, void, refund, mapping, journal and reconciliation actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report.

Browse connected topics:invoice credit note expense reconciliation journal entry supplier bill check report tax purchase approval mapping vendor double-entry

Was this guide useful?Your response is stored only in this browser.

Use Tax Detail, Summary and Liability reports

What you’ll accomplish

How it works

Follow these steps

Settings to check

Check it worked

Common mistakes to avoid

Related guides