Before getting started...
We recommend watching this quick training video (3 min), which gives a brief and strong understanding on how to enter sales in Budgeto. Learn how to use the two planning methods, and how to enter your sales ($) manually for any month within your financial forecasts!
Become a Budgeto expert by watching the other videos available! These training videos can be found in our Multimedia Gallery (Be sure to check back often, as more videos are in the works!).
Click here to access the Budgeto Multimedia Gallery
How to enter your FIRST sales entry
During your first visit, your SALES section will be empty (even if you have imported some accounting/historical data).
Start by pressing on the SALES menu to begin adding your sales information.
PRO-TIP: Don't stop at just one product/service, you can enter as many sales as you want into Budgeto! Multiple sales entered will help make your financial reports more detailed.
Click here to access the sales section within the Budgeto app
STEP 1: General information about your product:
1- DEPARTMENT: Add/create a department for your product (Accounting, Sales, Finance, etc.).
2- PRODUCT: Name your product.
3- SALE PRICE: This is where you enter the price of your product. This is the final price you are selling it at to your end user. Note that the price you enter here is without taxes. This price will be used to fill the numbers in step 3.
4- PAYMENT TERM: You have the choice of up to 12 months before, or up to 12 months after.
5- TAXABLE: If you collect the taxes when you sell your product, check this box.
6- COMMISSION: If you intend of giving a commission to a reseller, sales rep, etc.
7- HYPOTHESIS: This space is intended to write useful information about the product. This information will be available to all of whom you share your budget with. Note that when you export your budget, this information will not be available in the PDF and the Excel.
8- SAVE: This is the last step once you're done. Remember to save your work or else your information will be lost.
9- NAVIGATOR: Use these arrows and drop-down menu to quickly navigate/shift from one sales record to another.
STEP 2: Cost of Sales
The cost of sales is the sum of all the costs directly related to your products. "Costs of Sales" includes material, labor, and all other allocated overhead. It may be in "$ per unit" or a "% of the sale price" of your product.
- "$ per unit" means that your cost is fixed and never changes.
- "% of the sale price" means that your cost is variable, depending on the sale price of your product.
You are able to edit and/or add new variable costs with the nomenclature that suits you.
8- + COST: Add a new row to enter your information, ex: and additional cost of sales.
9- DESCRIPTION: Name of the associated cost.
10- COST: Enter a number and select from the drop down next to it if the number is:
- a % of the sale price
- a $ (cost) per unit
- a $ (cost) per new customer
11- PAYMENT TERM: You have the choice of up to 12 months before, or up to 12 months after. As we speak now, it's not possible to change it to a custom date.
12- TAXABLE: If you pay the taxes when you produce your product, check this box.
13- TRASH BIN: If you want to remove/delete a row.
STEP 3: Sales planning
The first step is to choose the method you want to use to forecast your sales between:
- Manual: if you want to enter your sales manually.
- Growth: if you plan an organic growth and loss of customers.
You have 2 options;
- You can enter the estimate Annual sales (1). By doing so, it will automatically populate the Units sold (Planning) board at (2). (You can always modify manually the grid generated afterwards).
- You can start by filling the Units sold (Planning) (2). Using this method will fill the annual sales automatically based on the numbers you entered in the sales price from Step 1.
Ex: Product A sells more in December than other months (Christmas decorations).
- You can always play with a combination of both, whatever suits your company's needs.
"Or just CLICK on the desired cell and edit the numbers!!!"
1- FREQUENCY: This is the frequency of the sale's occurrence of the product. Select if your product is sold monthly, yearly or per month (non cumulative) in case of one time sales (meaning you have a product that you plan on selling once to a one time customers).
2- START DATE: This is the month when the product starts being sold.
3- CUSTOMERS: This is the units sold in the first month of sales.
4- PRE-EXISTING CUSTOMERS: Check this box if customers existed before the beginning of your plan. If you check it, the grid is your sales schedule for the last year (the previous year of the budget). You need to fill it if you want the system to renew your annual customers from last year (the system will consider churn assumptions).
5- GROWTH: This is how much sale of this product increases organically (per month, year or recurring).
6- CHURN: This is how much sale of this product decrease organically (per month, year or non-recurrent).
For example: If you plan on selling a product to a one time customer (a one time sale), then YOUR CHURN RATE WOULD BE 0%.
PRO-TIP Click on the blue arrows next to "Growth" and "Churn" to expand the grid and modify your planning directly. Use this feature to change the Growth and Churn % to best represent the desired date you have selected.
IMPORTANT Don't forget to press on SAVE once you are done.
PRO-TIP Click on the arrow to the right of the word "SAVE" and select "Save & copy". This will allow you to save your current entry, and then bring you to a new entry page, where all the previous information is already entered.
This will allow you to make small modifications to the NEW current entry, without having to refill every box again.
How to edit your sales form
1- ADD, SAVE: Click here to add a new sales entry and to save any work being done in this menu.
2- EDIT, YEARLY, MONTHLY: Change the date layout of your sales data.
3- ACTION: Click here to quickly copy, delete, or edit any sales entry.
4- DRAG: Click and drag sales entries to quickly move them into other departments and/or their order.
How to use the Quick Edit menu
This menu offers three distinct display modes:
Allows you to make quick changes to all your records without having to enter into each form individually
View your budget on an annual basis
View your budget on a monthly basis
- For additional features, you may access the detailed form for each record by clicking on the pencil (in EDITING mode) or on the name of the record (in ANNUAL or MONTHLY view);
- You can easily replace / create new departments or categories by typing the desired name in the box and then save;
- Whenever you make a change to a record in EDITING mode, you can immediately see the impact in ANNUAL or MONTHLY view without saving your data;
- If you want to access a form or exit this menu, you must save your changes!
These buttons allow you to perform quick actions in EDITING mode:
Budgeto currently uses the JUST-IN-TIME (JIT) method when managing inventory.
You can access your inventory settings by clicking on the "Inventory" button in the sales form menu.
For more information about managing inventory within the Budgeto app, such has how to manually change your inventory planning (ex: PLANNING MANUAL PURCHASES), check out this article from our Knowledge Base: How does inventory work in Budgeto?
A) Example of a sale for a manufacturing company
Scenario (Manual Method)
A company manufactures "Product A" and sells it at 100$;
The cost of producing each unit of "Product A" is 25$ of raw material, 10$ of packaging supplies, 5$ of shipping and one hour of assembly (the cost for labor is 10$ per hour);
Cost of Sales
$25 of raw material + $10 of supplies + $5 of shipping + one hour of assembly at $10/hour = $50.
Your cost of sales is 50.00 $ per unit.
WARNING: if the labor used to assemble "Product A" is paid EVEN IF THERE IS NO PRODUCTION, then he is an employee and must be budgeted in the menu "Employees". Consequently, his cost should not be considered in your cost of sales as it is already budgeted in the menu "Employees". Your cost of sales would then be $ 40.00 per unit ($25.00 + $10.00 + $5.00).
B) Example of a sale for a Consultation Agency
Scenario (Manual Method)
A consultation agency sells consulting hours. Every hour of consultation is carried out by a subcontractor of the company. The consulting agency wants to make a profit of 100% on every hour sold.
Cost of sales
If an hour of a subcontractor costs 50$ and we want to make 100% profit on this hour, then we must sell each hour at $100. The cost of sales is then 50%, which means that for each hour sold, it costs the company $50.
Your cost of sales is 50.00% of the sales price.
WARNING: if your consulting hour is carried out by an employee of the company, your cost of sales should be 0%. Indeed, the cost of the employee shall not be considered in your cost of sales because it is already budgeted in the menu "Employees".
C) Example of a sale using the "Growth Method"
Scenario (Growth Method | SaaS)
A start-up company is selling a subscription to an online business application tool.
Here is some more information:
- The sales price is $10.00/month (which is taxable at 14.975%);
- No payment terms on the subscription;
- The payments are all done online using PayPal and Stripe, and costs 3% of the sales price;
- The start-up company uses an online advertising campaign to gain new customers. The cost of acquisition is $50.00 per new customer;
- Cost of sales is not taxable, and carries no payment terms;
- They wish to see a growth of 15% per month in the first year, 10% per month in the second year, 5% per month in the third year, 2% per month in the fourth year, and 1% per month in the fifth year;
- They also expect a churn (lost of customers) of 25% per month.
Enter the sales info
Enter Cost of sales
- Make sure the method is changed to growth;
- To modify the %change increase per month in the "Growth" box, click on the blue arrow to the left of the word "Growth".
IMPORTANT The first month (January) of "Churn" and "Renewal" are empty because it is the first month of sales for a subscription using the "Growth" model.
Therefore, it is impossible to have a loss of customers, and a renewal of customers in the first month of sales. They start on the second month.
NOTE This information can be found in the DEMO company, accessible to ALL users of Budgeto.
You can access the DEMO company by clicking on the Help Menu (?) in the top right corner, then selecting "Demo Company".
Now that you have finished entering all your sales information into BUDGETO, it's time to move on to your expenses (a cost that is paid in exchange for goods or services).
The "Expenses" menu allows you to create expenses, manage their occurrence, and to choose a payment term for your suppliers.
Expenses are just as important as Sales when building a budget. Get started with these articles from our Knowledge Base:
- How to add a new category/type of expense
Need help? These resources are for you!
1- There is a search bar at the top right of the screen, use it often! Use words that you see on the section you are dealing with in order to search for related articles in our Knowledge Base.
2- If you haven't found an answer to your question, create a support ticket and our team will find an answer for you:
Click here to create a new ticket for help
3- If you have any other questions about Budgeto, write us an email at: email@example.com
Happy Budgeting and know that we are here for you if you need help!
The Budgeto Team
Join the Conversation!
Follow us on our social media channels for Budgeto tips, how-to guides, company updates, and more!
Related Articles (Please refer to the links below)
- How to enter a discount on a sale
- How does inventory work in Budgeto?
- I'm new to Budgeto, where to start?
- What to do if I have a question/Customer support