If your Kenyan bank account won’t connect to QuickBooks Online, you can still keep your records up to date by downloading your bank statement and uploading it manually. Once uploaded, categorise each transaction and reconcile the account against your bank statement’s closing balance.
Watch: How to upload and reconcile your bank statement
Watch the A1 video: Bank Not Connecting to QuickBooks? Upload and Reconcile
How to reconcile your bank transactions when your bank won’t connect
You don’t have to wait for a direct bank connection to reconcile your accounts. Follow these steps to work with a downloaded bank statement:
Download your bank statement. Log in to your bank’s online banking platform and download the statement for the period you want to reconcile. Where available, use the CSV format so the transactions can be uploaded into QuickBooks Online.
Open Bank Transactions in QuickBooks Online. Navigate to the Bank Transactions section and select the relevant bank account. This is where you can manage transactions even when the account does not have an active bank feed connection.
Upload your statement. Use the upload option to import the downloaded CSV statement into QuickBooks Online. Follow the upload prompts to ensure the transaction information is brought into the correct account.
Categorise each transaction. Review the imported transactions and assign the appropriate category to each line. Check that the transactions are recorded against the correct accounts before proceeding.
Reconcile against your statement. Compare the transactions in QuickBooks Online with your bank statement. Use the statement’s closing balance as your reference and complete the reconciliation once the figures agree.
Watch out
Do not complete the reconciliation until the transactions have been reviewed and the closing balance agrees with your bank statement.
Watch the full QuickBooks training
Watch the full QuickBooks for Nonprofits and NGOs training from 56:30
Related articles
[Related QuickBooks How-To article 1 – add the published post link]
[Related QuickBooks How-To article 2 – add the published post link]
Need help with QuickBooks Online?
Need help setting up or managing QuickBooks Online for your organisation? Book a free 30-minute consultation with Remotix.