Help

Accounting reports in Google Sheets™ — Help and support

Last updated: November 10, 2026

The add-on puts your profit and loss by month, balance sheet, sales invoices, receivables and payables from e-conomic, Moneybird, Tripletex or Dinero into Google Sheets™, and refreshes them by itself. 14 days free with everything; then Free for one company, or Business at €19 a month.

Questions or a problem? Write to [email protected] and we answer on weekdays, within 24 hours. Tell us what the side panel says. Please do not send your access token or your accounts: we never need them to help you.

How do I get my first report?

Open a spreadsheet and choose Extensions → (the add-on's name) → Open. Press “Show me the demo company” to see a profit and loss report land in a new tab. Then press your accounting system's button under “Connect your accounting system”, approve the access, pick the report, the period and how often it should refresh, and press Import to a new tab.

How do I connect e-conomic?

Press e-conomic in the side panel. e-conomic opens its own page where you log in and approve read access for the add-on. Close the window when it says the company is connected. You can remove the access again in the side panel or in e-conomic under Settings → Apps.

How do I connect Tripletex?

In Tripletex, click your name at the top right, choose API access and create a new token with read access. Copy the token, press Tripletex in the side panel, paste it and press Connect. Your Tripletex plan must include the Integrations module.

How do I connect Moneybird or Dinero?

Press Moneybird or Dinero in the side panel and approve the access on their page. If you have more than one administration or company, each one is connected. Dinero's API needs Dinero Pro or Total, and Dinero's API does not give payables.

Why does my profit show income as positive and costs as negative?

That is how a profit and loss report reads: income adds, costs subtract, and the result is the profit. Your accounting system stores income as credit (negative). The balance sheet keeps the system's own signs: assets positive, liabilities and equity negative.

When does an automatic refresh run?

Early in the morning in the spreadsheet's time zone: every day, every Monday or on the 1st of the month, as you choose. It also runs when the spreadsheet is closed. If a refresh fails, the tab shows why in red in row 3, and the side panel shows it too.

Can I add my own formulas and charts?

Yes, on another tab. Refer to the imported tab with formulas such as =SUMIF('P&L · Company'!B:B;"Rent";'P&L · Company'!O:O). The imported tab itself is rewritten on every refresh, so anything you type into it is replaced.

I paid, but the add-on still says Free or Trial.

Press “I have paid – refresh” at the bottom of the side panel. Use the same Google account in Sheets as the email you paid with. If it still does not change after a minute, write to us.

How do I cancel or change my plan?

Press Manage billing at the bottom of the side panel. You can cancel, switch between Business and Bureau or monthly and yearly, update your card and download invoices there.

Links

Made by AddonNordic ApS, Aalborg, Denmark (CVR 46495985).

Google Sheets™ is a trademark of Google LLC. e-conomic, Dinero, Tripletex and Moneybird are trademarks of their owners; we are not affiliated with them.