Make sure your HISTORICAL BALANCE SHEET has already been entered first (manually or by importation from an accounting software such as QuickBooks Online). Your HISTORICAL BALANCE SHEET must be entered before performing manual variations. (Note, the last month used is the most important).


Click here to access the Historical balance sheet within Budgeto.


The Manual Variations Menu deals with the movement of money in the future that is related to your past. For example, you need to "teach" the system (Budgeto) when you will receive or move money associated with your accounts.
(Ex: Accounts Receivable, Accounts Payable, etc.)


The Manual Variations Menu is located at the top right of the application, in the historical data sub-menu of your company.




NOTE. You can change the year of your Manual Variations by clicking on the arrows (left or right) next to the current year used found in the top right corner.



LAST MONTH OF BALANCE SHEET is the amount entered in the last ACTIVE MONTH found in your historical balance sheet. It is important to balance this amount out (+/-) in the following cells to the RIGHT of the "Variationsline (colored BLUE). 
Once you balance this amount out, the BALANCE column to the far right will show 0. NOTE: You can enter the amount in multiple segments in multiple months, as long as the total matches the amount reported in the LAST MONTH OF BALANCE SHEET.


Months reported in budget shows which months in your Manual Variations are "active". The boxes that are checked green (found above each month) are considered active. To make your month "inactive", simply click on the green box to deselect them. "Variations" shows the current month(s) that are being used in your Manual Variations. 


EXAMPLE


In this example, the following amounts were entered into the HISTORICAL BALANCE SHEET for the LAST active month. Here is some more information:

  • The last active month in the HISTORICAL BALANCE SHEET was March 2020.
  • Accounts receivable of $15,000 will be RECEIVED in May 2020. As such, -$15,000 is being entered and will be recorded in the CASH FLOW of the budget. 
  • Accounts payable of $15,000 will be PAID in three separate payments of $5,000 in the following months (June 2020, July 2020, August 2020). Same principle for the CASH FLOW applies. 


  1. First step is to select the months to be used to the right of the "variations" line (May 2020-August 2020). These are the GREEN check mark boxes found above the cells. 
  2. Enter the $15,000 for Accounts receivable as a NEGATIVE amount in the May 2020 cell (-$15,000). Watch as the Balance 2020 total changes to $0.
  3. Enter $5,000 for Accounts payable as a NEGATIVE amount for the months of June 2020, July 2020, and August 2020. Watch as the Balance 2020 total changes to $0.



REMEMBER to click on the SAVE Button located in the top left of your screen to save your Manual Variations. If you leave the current page without saving, your progress will be lost.



--------------------------------------WHAT'S NEXT---------------------------------- 


Now that you have finished entering your historical data with BUDGETO, it's time to fill out your budget.
It's important to focus on your company's FUTURE and what's to come so you can be better prepared and have everything laid out for you. This is why at this stage we are asking you to fill up forms rather than extrapolate the past. We want you to think differently, we want you to plan for what you have never done.

That's why it is critical to have a solid understanding of your financial projections. Get started with these articles from our Knowledge Base:


I'm new to Budgeto, where to start?
 

How to enter sales


--------------------------------------------------------------------------------------------- 


Related Articles (Please refer to the links below)


-How to enter your HISTORICAL DATA Manually

-How to fill the 4 forms in the Balance Sheet

-How to LINK QuickBooks Online (QBO) to BUDGETO?

-Possible Errors in the Historical Data Menu