Before you start

If you want to use connected accounts, make sure your Acumatica integration is set up first. See: *Getting Started — How to Connect Acumatica to ALK.* If you haven’t connected Acumatica yet, you can still reconcile using the manual upload path.

Getting Started with Account Reconciliation

1. From the ALK home page, scroll down to the workflows section and select Reconciliation.

2. You’ll land on the Reconcile tab by default. The History tab shows all previously run reconciliations.

   

3. Choose your method: Option A - Connected accounts (Acumatica)

   1. Set your date range using the Start Date and End Date fields

   2. Under Select bank accounts, click Select accounts and choose the relevant accounts

      

   3. Under Select GL accounts, click Select accounts and choose the corresponding GL accounts then Add Selected Accounts

      

   4. Click Continue

   Option B - Manual file upload

   1. Under Upload bank statement, click Choose file and select your bank statement

   2. Under Upload GL export, click Choose file and select your GL export

   3. Proceed to Step 3 before clicking Continue

      

4. Configure advanced matching options (optional)

   Before running the reconciliation, expand Advanced matching options to adjust how ALK matches transactions. All four settings are on by default:

   • Fuzzy matching: Matches similar transactions even if descriptions differ slightly. Leave on unless you need exact description matches only.
   • Date tolerance — Allows a ±2 day window when matching transaction dates. Useful for transactions that post on different days across systems.
   • Amount tolerance — Allows a $0.50 variance when matching amounts. Accounts for minor rounding differences.
   • Ignore bank fees — Prevents small bank fees from being flagged as discrepancies. Turn off if you need bank fees visible in your reconciliation output.

   Toggle any setting off if your reconciliation requires stricter matching.

   

5. Click Continue to run the reconciliation. ALK will process the data and return matched and unmatched transactions.

Related articles

• How to Connect Acumatica to ALK

Troubleshooting

Try the following before contacting support:

• Confirm your bank statement and GL export are in the correct file format
• Check that your date range is set correctly and covers the period you intend to reconcile
• If using connected accounts, confirm your Acumatica integration is still active under Integrations in ALK
• Try toggling off advanced matching options and re-running the reconciliation to rule out matching configuration issues