Skip to main content

Manual reconciliation with QuickBooks

Emelie Rantatalo avatar
Written by Emelie Rantatalo
Updated this week

How to manually reconcile Mimo transactions in QuickBooks

Create accounts in QuickBooks

In QuickBooks, go to Accounting > Chart of Accounts > New. Set the account type to Cash at Bank and in hand, choose the relevant detail type, and create accounts for both Mimo Balance and Mimo Flex.

Export transactions from Mimo

Log in to Mimo, go to the Account tab, and click Export transactions. Choose QuickBooks as your platform, select a date range, and export two statements—one for Mimo Balance, one for Mimo Flex. Each file includes the date, description, and amount.

Upload transactions in QuickBooks

In QuickBooks, go to Bookkeeping > Transactions > Bank transactions and click Upload transactions. Upload your file, select the matching account, map columns, and confirm import.

Match and categorise transactions

Go to Transactions > For Review. QuickBooks auto-matches where possible. For unmatched items, click Find Match to assign manually.

Final reconciliation

Check that your opening balance matches your bank statement. Go to Settings > Reconcile, select the account, enter the ending balance and date, and reconcile to a zero difference.

For more details on the reconciliation in QuickBooks, click here.

Did this answer your question?