Spreadsheet Reporting & Ledger Sync software for accounting firms

Read-only or write-back, and whether you actually want write-back. FinOptimal splits this deliberately: Wrangler streams QBO into Sheets, Booker pushes back. Bulk write-back is where the audit exposure sits, because a spreadsheet push of 400 journal lines gets no per-entry review before it hits a live ledger. Ask whether the tool stamps a traceable batch reference on every pushed entry, whether it can update and delete existing transactions or only create them, and whether each staff member connects under their own credentials so the QBO audit log names a person rather than a shared app connection.

Google Sheets only, or Excel too. G-Accon, Wrangler and Booker are Google Sheets add-ons with no Excel version. LiveFlow and Amalgam do both. This is not a preference question if your clients' CFOs and their lenders work in Excel, because array behaviour, add-in support and file handling differ enough that porting a finished model across is a rebuild, not a toggle.

How refresh actually runs. Scheduled overnight, triggered by ledger events, or a person clicking a button are three different products. G-Accon puts event-driven refresh behind its Plus add-on at roughly 30 percent on top of the base plan. Ask the shortest supported interval, whether a refresh fires when nobody has the sheet open, and what a failed refresh looks like: a workbook that silently shows last week's numbers on the 15th is more dangerous than one that throws an error.

Pricing counts connected client files, not seats, and it scales fast across a book. G-Accon is roughly $150 per month for 25 companies, $300 for 50, then about $10 per additional company, and it is priced per product, so QBO clients and Xero clients are separate subscriptions. Wrangler is $99 per month for a single file with multi-file quoted. Booker is $99 or $149 depending on whether you need invoice and bill imports. Amalgam is $99 solo and $199 per user per month for a team. Translucent charges per app, free up to four entities and about £49 to £98 per app per month for unlimited. Price your real client list, not the demo.

Multi-entity: real consolidation or stacked columns. Ask whether the product holds a group chart of accounts that maps each entity's own COA, handles FX translation, and identifies and eliminates intercompany balances rather than summing three P&Ls side by side. Translucent sells intercompany reconciliation with recharge rules and write-back as a separate app for exactly this reason. A workbook that adds entity columns will not tie once there is genuine intercompany activity.

What happens when the connection breaks mid-month. OAuth tokens to QBO and Xero expire, and a client rotating a password or revoking app access silently kills the pipe. Ask who gets alerted and how fast, whether already-pulled history survives a disconnection or vanishes with it, and who can re-authorise when the token belongs to the client rather than to your firm. Also ask where the data physically sits: a workbook in a client's Google Drive is not under your firm's retention or offboarding control.