Ubouk
Sign in
← Help Center
Accounting & financial reports~4 min · 3 steps

Read taxes collected and refunded

Compare collected, refunded and net tax by component for settled payments.

  1. 1

    Choose the report period

    Open Read taxes collected and refunded from Reports. Choose a period preset or enter From and To. Optionally select a Batch, then Apply. Dates and batch work together, so widen the period if a batch appears incomplete. Financial reports require owner, administrator or finance manager access.

    Screenshot: Choose the report period. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

  2. 2

    Read cash-settled tax by component

    For each Tax component, compare Collected, Refunded and Net. Net equals collected minus refunded. A partial payment contributes only its allocated tax; collecting an older invoice appears in the collection period. Unallocated tax indicates missing historical detail, not zero tax. Use Tax remittance helper to compare this cash view with tax invoiced and credited.

    Screenshot: Read cash-settled tax by component. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

  3. 3

    Export the filtered report

    Open Export and choose Excel workbook (.xlsx) or CSV file (.csv). The file uses the active filters and current language. The screen shows at most 500 rows; exports include every matching row. If there are no results, check the date and clear restrictive filters. If a historical journal backfill warning appears, have the missing history completed before treating totals as complete.

    Screenshot: Export the filtered report. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

Keep going

Accounting & financial reports
Prepare the tax remittance worksheet

Compare output tax invoiced and credited with tax collected and refunded for a filing period.

Accounting & financial reports
Map tax accounts and invoice tax labels

Set the tax account, agency, registration number and bilingual invoice description for each component.

Accounting & financial reports
Read detailed cash sales and fees

Trace settled sales, allocated tax, refunds and processing fees by invoice line.