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:
-
Go to the Gear icon, then select Chart of accounts.
-
Look for the account you want to reconcile, then click View register.
-
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.