Skip to main content
All CollectionsAuto ReconciliationAuto Reconciliation Setup
Reconciling Mimo transactions in QuickBooks
Reconciling Mimo transactions in QuickBooks
Emelie Rantatalo avatar
Written by Emelie Rantatalo
Updated yesterday

Before you start

Set up Accounts in QuickBooks

  • Go to Accounting > Chart of Accounts > New.

  • Select Account type as ‘Cash at Bank and in hand’.

  • Choose the relevant detail type.

  • Set up accounts for both Mimo Balance and Mimo Credit.

Step 1. Export transactions from Mimo

  1. Log in to your Mimo account.

  2. Go to the Account tab.

  3. Click on ‘Export transactions’.

  4. Choose QuickBooks as your accounting platform.

  5. Select the date range for the transactions.

  6. Export two statements: one for Mimo Balance and one for Mimo Credit.

The file will include the Date, Description (Supplier/Payee), and Amount (GBP).


Step 2. Upload transactions to QuickBooks

  1. Open QuickBooks.

  2. Navigate to Bookkeeping > Transactions > Bank transactions.

  3. Click on Upload transactions.

  4. Drag and drop your downloaded file or click to upload.

  5. In the QuickBooks account dropdown, select the relevant account.

  6. Match the columns from your file with QuickBooks fields.

  7. Select the transactions you want to import and confirm by clicking Yes.

  8. Click Done to finish.

Step 3. Match and Categorise Transactions

  1. Go to the Transactions tab under the Bookkeeping menu.

  2. Select the account you uploaded transactions to (it will be shown automatically).

  3. Under the For Review tab:

    QuickBooks Auto-Match: Transactions will be marked in green if they match existing sales or purchase invoices.

    Manual Match: If no match is found, click on Find Match to manually search.

  4. After reviewing, your transactions are now successfully imported and matched.

Step 4. Final Reconciliation

  1. Review Opening Balance: Ensure your QuickBooks opening balance matches your bank statement.

  2. To start Reconciliation, Go to Settings > Reconcile, select the account, and enter the ending balance and date.

  3. Compare Transactions: Match transactions from your bank statement with those in QuickBooks. Mark them as reconciled if they match. Your goal is to have a zero difference.

For more details on the reconciliation, visit QuickBooks Reconciliation Guide.

Did this answer your question?