# Income statement import

## Model Documentation

## Income Statement Import

The Income Statement Import tab lets you map your accounting system’s GL accounts to a P&L Category to be shown on the FS tabs. Some notes:

- It’s ok to include blank rows as well as total rows (as long as neither are tagged with categories).
- All positive amounts below are the normal balance that given account (e.g. revenue will be a positive number, as will payroll expense).
- Only months prior to and including the most recent actuals month (the input found on the “Update Checklist” tab) will be incorporated on the FS tabs.
- A good sanity check: compare the FS tab totals to this tab’s totals.
- If there’s a separate revenue line item you need to account for that isn’t captured anywhere else in the model, you can use the “Other Non-Recurring Revenue” row on the “Revenue” tab (and update it each month).

## Account Mappings

If you choose “Default”, the Account Mapping table (on the “Advanced Inputs” tab) will handle allocations. You can also choose a different option to override the default.

For these P&L – Detailed Categories:

- “T&E”
- “Software Subscriptions”
- “Consulting & Outside Services”
- “Other”

The following options for P&L Line Item Category should **not** be selected:

- “Default”
- “Allocate based on department payroll”
- “Allocate to each P&L Line Item expense”

If you do choose one of these, they’ll simply go to “General and administrative”. If you need to allocate these to multiple P&L Line Item Categories, you can manually enter the same GL account on separate rows, tagging each row with a different P&L Line Item Category.

For the following P&L – Detailed Categories :

- “Interest (Expense) Income, net”
- “Other Income (expense)”
- “(Benefit from) income taxes”

You **must** select either the “Other Income (expense), net” or “(Benefit from) income taxes” P&L Line Item Category (otherwise the P&L won’t match the P&L – Detailed in aggregate).