Total Access Docs
Guides

Accounting Export

Sync financial data to Xero, QuickBooks, Sage, and Dynamics 365.

Accounting Export

Total Access can publish financial documents (invoices, bills, payments) to external accounting platforms: Xero, QuickBooks, Sage, and Dynamics 365 Business Central.

Supported platforms

PlatformAuth MethodDocument Types
XeroOAuth 2.0Invoices, bills, payments, contacts
QuickBooksOAuth 2.0Invoices, bills, payments, customers
SageOAuth 2.0Invoices, bills, payments, contacts
Sage (ZA)API Key + Basic AuthInvoices, bills, payments
Dynamics 365 Business CentralOAuth 2.0 (Entra ID)Sales invoices, purchase invoices, payments

Connecting an accounting platform

  1. Navigate to Total IntegrationAccounting Export
  2. Select your platform (Xero / QuickBooks / Sage / Dynamics 365)
  3. Click Connect
  4. Complete the OAuth flow (for Xero/QuickBooks/Sage/Dynamics 365) or enter API credentials (for Sage ZA)
  5. Select which document types to sync
  6. Save — a test sync will be performed

How it works

  1. When a document is finalized in Total Access (e.g. invoice is approved, bill is posted), it is queued for export
  2. The export adapter transforms the document into the target platform's format
  3. The document is pushed to the accounting platform via their API
  4. The export result is logged (success/failure with error details)
  5. Failed exports can be retried from the Accounting Export panel

Configuration

Document type mapping

Total Access TypeXero TypeQuickBooks TypeSage TypeDynamics 365 Type
InvoiceInvoiceInvoiceSalesInvoicesalesInvoice
BillBillBillPurchaseInvoicepurchaseInvoice
PaymentPaymentPaymentPaymentsalesInvoicePayment / purchaseInvoicePayment
ContactContactCustomerContactcustomer / vendor

Dynamics 365 Business Central uses Microsoft Entra ID (Azure AD) for OAuth 2.0 authentication. A dedicated Entra app registration with the Financials.ReadWrite delegated permission is required. The adapter resolves the BC company ID automatically after OAuth consent. Multi-environment support (production/sandbox) is available — the environment is encoded in the stored tenant ID.

Sync settings

SettingDescription
Auto-syncAutomatically export documents when finalized
Sync intervalHow often to check for pending exports (default: 15 min)
Retry failedAutomatically retry failed exports
Notify on failureSend notification when an export fails

Testing the export

curl -X POST https://totalaccess.co.za/api/v1/integrations/accounting-export/test \
  -H "Authorization: Bearer YOUR_JWT_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "platform": "xero",
    "document_type": "invoice",
    "document_id": "inv_abc123"
  }'

Disconnecting

curl -X POST https://totalaccess.co.za/api/v1/integrations/accounting-export/disconnect \
  -H "Authorization: Bearer YOUR_JWT_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "platform": "xero"
  }'

Disconnecting does not delete previously exported documents from the accounting platform. It only stops future exports.

On this page