We have a senior officer who periodically comes in to reconcile bank accounts. Is there a way for me to reconcile offline (in Excel) if he hasn't done the rec in QBO yet?

Thank you for reaching out to the Community, Jack.

Yes, you can do a reconciliation offline through Excel to keep your records up to date. You can export them so you can have a copy of your transactions.

Here's how:

1. Go to the Gear icon, then select Chart of accounts.

2. Look for the account you want to reconcile, then click View register.

3. Click the export icon beside the gear icon.

    

    

   In this way, you can get a copy by exporting your transactions to an excel file.

    

I've attached a screenshot for your visual reference.

You can check out this article in case there are errors after you reconcile: Fix issues at the end of a reconciliation in QuickBooks Online

Moreover, you can check this article to learn what the supported formats in importing files in QBO: Import/export CSV files

Don't forget to leave a comment if you have more concerns related to reconciling your transactions in QBO. We're always here to help.