Customer work, connected.

Help & supportMyAccount
Accounting & Bookkeeping · How-to guide

Configure sales invoice account mappings

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

Define how customer invoices post to accounts receivable, income, discounts, taxes and item-specific accounts.

Audience: Finance administratorsFeature: Invoice mappingsModule v1.4.5
Jump to steps
Where to goAccounting → Settings → Mapping Setup → General
Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Settings: Edit. 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

Define how customer invoices post to accounts receivable, income, discounts, taxes and item-specific accounts. 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

Invoice conversion is connected to invoice add, update, status, cancellation and deletion hooks. Exact posting occurs according to status and module settings.

A typical accrual invoice debits accounts receivable and credits income and tax payable, but actual lines depend on configured items, taxes and discounts.

If an invoice is cancelled or deleted, use the module's supported lifecycle so related accounting records can be handled consistently.

Follow these steps

  1. Verify the approved receivable control account.
  2. Go to General mappings.
  3. Set the invoice income and receivable accounts.
  4. Configure tax mappings for every active sales tax.
  5. Add item or item-group mappings where revenue must be segmented.
  6. Save and create a controlled draft invoice.
  7. Trigger conversion and compare the accounting lines with invoice totals.

Settings to check

Accounts receivableDebit control account for unpaid customer invoices.
Income accountCredit account for revenue when no item-specific mapping overrides it.
Item or item-group accountProvides more precise revenue classification.
Tax payable accountReceives output tax from invoice tax lines.
Discount or adjustment accountHandles configured invoice reductions or adjustments.

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 map accounts receivable as an income account.
  • Test tax-inclusive and tax-exclusive cases used by the business.
  • Check discounts and rounding adjustments.
  • Confirm foreign-currency treatment before live use.
  • 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.

Search the platform, integrations and practical Help Centre guides.

Press Esc to close.Browse every page