ABCDEFGHIJKLM
1
2
Step One: Set up AccountsClick here to begin
3
Enter all income and expense accounts, last four digits of the account number, and starting balance. Fields in yellow will calculate automatically. Mark account as Inactive if it is no longer in use.
4
5
6
Step Two: Set up Income Sources List and ForecastClick here to begin
7
Enter the income source name and project. Create one source named Transfer to track transfers between accounts. Enter forecast information on each row as needed in positive numbers. Mark income source as Inactive if it is no longer a source.
8
9
10
Step Three: Set up Expenses List and ForecastClick here to begin
11
Enter the expense, type, and account that will be used. Create one expense named Transfer to track transfers between accounts. Enter forecast information on each row as needed in negative numbers. Mark expense as Inactive if it is no longer an expense.
12
13
14
Step Four: Enter Income and Expenses in LedgersFor Income:
Click here to begin
15
Enter incoming and outgoing expenses on the provided ledgers. Enter the date, write a description, choose the income or expense from the dropdown menu, the amount - positive for income, negative for expense - and choose the account used. Check the box marked "Cleared" if the money has cleared the account. If "Transfer" is selected, transfer account column will highlight yellow to prompt a selection.
16
For Expenses:
Click here to begin
17
18
19
Step Five: View SnapshotsWeekly Snapshot
20
View snapshots to see week, month, and year at a glance. All colored fields will populate automatically and are protected from changes. Use dropdown menus on Monthly Snapshot to change the year and month. Use dropdown menus on Yearly Snapshot to change the year and view specific income sources and / or expenses. Compare Forecasted amounts on Monthly and Yearly Snapshots to actual income and expenses.Monthly Snapshot
21
Yearly Snapshot
22