AccountsIQ, in step with operations
A multi-site business needed a reliable link between its operations system and AccountsIQ. Invoices had to carry stock, location and GL detail, and payments had to agree in both systems.
- Accounting package
- AccountsIQ
- Service
- Accounting & Finance Systems
What needed solving
- Payments were recorded in both systems, so balances never quite agreed.
- Sales invoices needed stock item, location and sub-location detail as well as GL and tax codes.
- Every type of purchase invoice had to land in the supplier ledger.
- Missing customer or supplier accounts stopped invoices from posting.
The outcome
- Payment status agrees across operations and finance.
- Invoices arrive in AccountsIQ with full GL, stock and location detail.
- Fewer failed postings thanks to automatic account creation.
What we built
Reference data sync
Customers, suppliers, tax codes and nominal (GL) codes are imported from AccountsIQ with the fields operations need: reference, name, address, postcode, telephone and account number.
Detailed sales invoices
Each invoice line carries quantity, stock item, price, tax code and rate, GL code, and item location and sub-location.
Purchase invoices
Supplier invoices post to AccountsIQ and land in the supplier ledger.
Two-way payments
Payments sync in both directions, so a receipt recorded on either side updates the other.
Automatic account creation
Missing customers or suppliers are created in AccountsIQ during invoice sync, with a default bank account and tax code applied.
Sync history
A history tab lists every run. Failed items expand to show the exact reason so they can be fixed and resent.
What syncs, and in which direction
AccountsIQ → Operations system
- Customers
- Suppliers
- Tax codes
- Nominal (GL) codes
- Payments
Operations system → AccountsIQ
- Sales invoices
- Purchase invoices
- Payments
Engineering highlights
- Bidirectional payment synchronisation
- Stock, location and sub-location carried on invoice lines
- Customer and supplier codes matched on reference number to prevent duplicates
- Default bank and tax codes applied to new accounts
Tools & technologies
- AccountsIQ API
- REST APIs
- Field mapping
- Two-way sync
- Audit logging
Other integrations we have delivered
One-click Xero invoicing
A Xero integration that pushes approved invoices, credit notes and payments with one click, syncs customers both ways and imports Xero tax rates and account codes.
Read case studyQuickBooks Online integration with one-click posting
A QuickBooks Online integration that syncs customers both ways, imports tax and account codes, and posts approved invoices, credit notes and payments with one click.
Read case studySage 200 Professional moved to Azure, with bespoke apps and mobile ordering
We moved a Sage 200 Professional set-up from a physical server to Microsoft Azure, then built reporting, sales target and HR web apps and a mobile ordering app that sends orders straight into Sage 200.
Read case studyWant AccountsIQ connected to your systems?
Book a free, no-obligation consultation. We will review your current processes and show you where automation and better reporting can save time and money.