Once you’ve made the three plans in Schedules - Plans, you’ll want to come back throughout the year and update the schedules with Actuals; these will populate your Profit & Loss, Budget Variance, and other reports.
There are two ways to put in your actuals - either by choosing the “Actuals” link next to each Plan and enter in the actuals there, or to Import a spreadsheet from your accounting software with the information (as long as your software can separate each month’s expenditures into a different column).
To use the Accounting Data Import tool to upload Actuals:
Export your profit and loss report, with monthly buckets, from your accounting system.
FINANCIALS > SCHEDULES > Open one of your already created plans.
Click Upload Spreadsheet button at the top right of your screen. [This will only appear if you already have created a plan with categories.]
Add File, then follow the Wizard Prompts to define your file mapping to Conservis. Not all columns need to be mapped to Conservis. Click Next.
Map the Categories from your file to the Budget Categories created in Conservis. [Ideally, the same naming convention was used to help with the matching process.]
Review the data that will be imported into Conservis for accuracy. If all looks good, click Save. After import, you can edit plans, if needed.
Note: You might notice there are two other items in the menu, Transport Costs and Revenue Deductions. Both of these are older functionality that have been superseded by other tools; if you do want to add in your expected trucking costs or some other deduction to revenue, we recommend entering it as an Overhead expense.