Prepare your data before you create your plan

Use the following guidelines to prepare your data to upload.

Income statement (P&L) accounts data

When you upload data to Sage Intacct Planning, your data is used to create budget lines with the same classifications of the accounting line items reported on a standard income statement:

• Revenues and expenses are reported with their natural signs. That is, revenues are reported as negative indicating a credit. Expenses are reported as positive indicating a debit.

  For example, if your revenues are reported as positive numbers, change the amounts to negative, or multiply them by -1.

  

• Upload monthly balances for each period.

• Make sure for each line item there’s a corresponding account number and relevant account group in a detailed format, such as revenues, cost of revenues, and so on.

Balance sheet accounts data

You can upload balance sheet line items for:

• Future Planning use in the balance sheet report

• Future budget versus actuals analysis and import of balance sheet actuals

If you upload line items with balance sheet account data, keep in mind that:

• Bringing in opening balances for your budget period (when you explicitly map the opening balances column) is recommended for use as a starting point for balance sheet financial reports

• The monthly cumulative amounts are disregarded