Sheetgo’s Income statement template lets you:
Automate data transfer between the income and expenses files.
Generate updated income statements.
How does the Income statement template work?
When you install the Sheetgo Income statement template, three Google Sheets files are created:
Expenses inputs: Share this file with the people responsible for payments. These expenses might include taxes, purchases, salaries, and other outgoings.
Income inputs: Share this file with the people responsible for processing invoices. Every time the company receives money, it's logged here.
Income Statement: This file has an automated income statement, an expenses report, and an income report.
Using the Income statement template
Step 1: Set it up
Sheetgo creates the connections and copies the template files to your Google Drive.
The template will open when the process is completed.
Step 2: Enter your data
Open the Income inputs file.
In the Inputs tab, select the year you want to analyze.
In the Income tab, delete the sample data and replace it with your data.
Click the files icon in the right sidebar to see the list of documents.
Open the Expenses Inputs file.
In the Expenses tab, delete the sample data and replace it with your data.
Step 3: Update your connections
In the workflow overview, click Run all automations to update data in Income statement.
Once the workflow update is complete, open the Income Statement to see the Income statement monthly tab to see data imported from the other spreadsheets, ready for further analysis.
Step 4: Automate transfers
Automate your workflow to always have updated data in the master sheet.
Step 5: Share files
You can share files from your Google Drive, or share the entire workflow to collaborate with your colleagues in Sheetgo.