Your financial statements in Google Sheets, updated daily.

Before you start

To connect, you need to be able to manage settings or app connections in Imprest, and a Google account that should own the spreadsheet. Imprest creates the spreadsheet in that account and works only with the files it created there. It never reads your other files.

Connect Google Sheets

1. In Imprest, open Apps, choose Add a connection, find Google Sheets and choose Connect.
2. Choose Connect Google Sheets. Imprest sends you to Google.
3. Pick your Google account and allow access.
4. Back in Imprest, the first sync runs right away and creates the spreadsheet. Choose Open spreadsheet to see it.
5. Under Report tabs, choose the reports, the Period and the Basis, give it a Name if you like, then choose Save settings. Changes apply on the next sync.

You can also start from a report. Open the report, choose Sync in its header, pick a spreadsheet or a new one, and choose Sync now. Sending a report this way needs permission to manage settings.

What goes to the spreadsheet

Each report you turn on becomes a tab: Profit & Loss, Balance Sheet, Trial Balance, AR Aging and AP Aging. The standard set is the first three, on accrual basis, for this month. You can also break the P&L down by month, or by a tracking category.

• The P&L uses the period and basis you chose.
• The Balance Sheet and Trial Balance are accrual balances as of the end of the period, or today if that's earlier.
• The aging tabs show what's open on the day of the sync.

Each spreadsheet has its own settings, so you can keep several: an accrual board pack and a cash-basis trial balance for your tax preparer, for example. One Google account can hold more than one.

Imprest clears and rewrites its report tabs on every sync. Tabs you add yourself are never touched. For your own formulas, point at the Data tab (stable columns, one row per account) or named ranges such as Imprest_NetIncome, because cell positions on the report tabs shift as your accounts change.

Day to day

• The spreadsheet refreshes once a day. Choose Sync now on its card for a fresh copy before a meeting or a close.
• Last synced shows when it last refreshed, and Recent sync activity lists each run.
• To add another spreadsheet under the same Google account, choose Add spreadsheet. To use a different Google account, choose Connect another account.
• Sharing is a Google setting. Being in your Imprest company doesn't by itself let someone open the file. A teammate can choose Request access when they pick the spreadsheet from a report. The person who connected the account sees the request under Access requests and can choose Share (view only) or Share with edit.
• A number wrong in the spreadsheet is wrong in the books. Fix the transaction in Imprest, then sync.

Common problems

• "Automatic syncing is paused after an error." Fix what the message names, then choose Sync now to retry.
• "Google asked us to re-authorize this connection." Choose Reconnect and sign in to Google again.
• The spreadsheet was deleted. The next sync creates a new one. Use the Open spreadsheet link in Imprest, since an old shared link won't work.
• A custom date range isn't supported. The spreadsheet falls back to This month and says so. Choose one of the listed periods instead.

Remove or disconnect

• Stop one spreadsheet. Choose Remove on its card, then Remove spreadsheet. Imprest stops writing to it; the file stays in your Google account.
• Disconnect the Google account. Choose Disconnect account and confirm. Every spreadsheet on that account stops syncing. Nothing is deleted, and if you reconnect, syncing resumes into the same files.

Your books don't change either way. The spreadsheet was only ever a copy of your reports.