In this article

    Banana Accounting Templates

    Income & Expense Accounting for a Company (SME)

    Universal
    Income & Expense Accounting
    Business
    | Tags: Universal

    How to manage your Business Finances with Simple Accounting. Banana is the perfect Accounting Software to keep track of your small or medium Business income and expenses. You can easily create a Budget, get the Balance Sheet or the profit and loss statement to control your company's liquidity. This template uses the Simple Accounting method and is perfect for those who want to manage their finances with little accounting knowledge.

    Template ID : +11123

    Banana Accounting & Application

    Managing your business accounting with Banana is like doing it with Excel, but faster and easier. Thanks to the ready-to-use template, you start right away, you just have to enter the data.

    With the budget you will know in advance how much liquidity your business will have and how long it will last, when and what expenses you will face and what income you can count on. You can simulate the reduction of expenses and see what effect it has on business finances, understand future sales volumes and whether your capital will be enough. You can always modify and correct your file, so it's easy to update your forecasts.

    This guide will help you manage your business accounting in the best way and solve your financial problems.

    You don't have Banana Accounting Software yet? Click here to download it!

    Create your file

    • Create a new file, starting from this template (Template ID  +11123), using one of the methods explained. 
    • With the command File → File properties sets the period, the company name and the basic currency.
    • With the command File → Save as save the file. It is useful to enter the company name and year in the file name.
      For example "company-2022.ac2".

    See also Organize accounting files locally, online or in the cloud

    Adapt accounts and categories tables

    Before creating your own cash flow, you need to quickly adapt your account and categories to your specific needs.

     

    Accounts table

    The Accounts table only shows the  liquidity in your possession (Cash, Bank, Post...). You can customize it by changing the account name, description and opening balance.

    accounts table

     

    In your Account Table you should also add the Assets and Liabilities of your company. 

    accounts table liabilities

    If you have different Customers and Suppliers you can create the section "Cost Centers" in order to categorise them.

    account table cost centers

     

    Categories table

    This table contains the income and expense categories and the change in capital. You can edit these categories by adding new items, changing the category name, changing the order and deleting categories that you don’t need. At any time, you can see the updated balances of each category.

    categories table

     

    Create your Budget

    The interesting innovation of our Accounting Software is the possibility to create cash flow forecasts to control liquidity and make timely decisions for your business.

    For this reason, we now recommend that you create your own cash flow forecast. Go to the Budget table: this table contains all the cash inflows and outflows that you will have during the year.

    To create the forecast correctly, follow these simple steps:

    • Insert operating income
    • Insert operating expenses

     

    Insert operating income

    Start by listing all the operating income you have and the amount of it. Cash sales is the main income, but there are others depending on your activity.

    Operating Income may include:

    • Cash sales
    • Miscellaneous cash receipts
    • Collections from customer credit accounts
    • Interests

    To insert a transaction in the budget you must enter the date (when you expect to have that income), the end date (if needed), the repetition (how often this income is repeated, if weekly, monthly or annual), the description, the amount in the income column and the income category.

    In the template you will already find typical ready transactions where you can quickly enter only the amounts. You can still insert new transactions, edit and delete them.

    To be as precise as possible with the estimate, look at last year’s values, rounding down the amount when you want to be more cautious.

    Tips:

    • Only rely on assured income
    • Group the income according to their repetition (weekly, monthly, annual, …)

    budget table

    Insert operating expenses

    Now it’s time to list all the operating costs. As you did for the income, here you have to estimate expenses by looking at last year’s values, but rounding up the amounts when you want to be more cautious. It’s always better to make an inaccurate forecast at the beginning of the year, than to have surprises of higher expenses.

    Operating costs may include:

    • Salaries
    • Payroll
    • Rent
    • Insurances
    • Advertising and promotion
    • Utilities
    • Travels
    • Telephone
    • Bank charges
    • Interests

    Tip:

    • Group the expenses according to their repetition (weekly, monthly, annual, …)

    budget table

    Control your cash flow forecast

    It’s important to know right away whether your business, thanks to your estimates, generates a positive cash flow or not. Are you curious, aren’t you? The generation of the forecast report will give you the answer!

    To do this check is very easy: just go to Reports → Enhanced statement with groups, and from the list that appears choose the Yearly forecast report. Press OK to view the forecast report.

    A goal of any activity is certainly to have a positive cash flow, because only this allows it to survive, or rather to pay suppliers, reimburse debts, ... Check the Net cash change item (at the bottom of the report) and make sure that you have a positive result (Inflow). If so, you can be happy, because you are managing your business well!
    On the other hand, if you have a negative net cash flow (Outflow), it means that unfortunately your business has difficulties to manage liquidity. What you need to do in this case is first of all to recheck well both your estimated income and expenses, if there are any adjustments to be made or errors to be corrected, that improve the cash flow. If you still have a negative cash flow, you need to think about actions to be taken to improve liquidity management from next year or when the forecast period starts. Most likely you will have to try to reduce your operating expenses.

     

    yearly forecast

    In addition to the annual forecast, always in Reports → Enhanced statement with groups, to have even more detailed control over the liquidity trend (for example how it behaves during the year), you can choose monthly, quarterly and 4-years reports, or create your own report.

    yearly forecast

    yearly budget

     

    Enter the transactions

    With the cash flow forecast under control, you can start register the various real liquidity transactions and compare them from time to time with the expected values.

    Insert the transactions

    Daily transactions must be inserted in the Transactions table. Making a registration is the same process as you did for the forecast in the budget table (the only difference is you don’t have the repeat column). There are also some examples in the table that you can delete and edit.

    transaction table

     

    Check the movements with account cards

    When you gradually enter your transactions, it could be useful to check how the cash account or a particular expense category has evolved over time. To do this you can view the respective Account/Category Card.
    For example, by selecting the Cash account card you will have a summary of all its movements. By also clicking on the chart option at the bottom, you have an even more immediate view of the account's performance.

    Tip: Check your Cash account at least once a month to see immediately how it is progressing and compare it with past months.

    account card

     

    Check the difference between balance and budget

    For more control over your performance, you can go to the Account or Categories table, selecting the Budget view and look at the Diff.Budget column, which shows you the difference between the real balances and the values you had budgeted. In this way you have an additional indicator to understand if you are following the budget well and to take better decisions.

    budget and balance difference

     

    Compare the Forecast with the Balance Sheet

    At any time of the year you can create your bilance sheet, which is a financial report of your assets, liabilities and equity. You can also compare your current situation with the forecast to understand if and where you are spending more, in order to take decisions in advance. At the end of the year you can make the final comparison between the actual report and the forecast to see if you have achieved the expected net cash flow.

    Create the control report from the menu Reports → Enhanced statement with groups → Yearly report compared to forecast.

    yearly forecast compared to balance

    If you want to have a more precise and targeted view, you can create reports with monthly subdivision, which also include the difference between the balance and budget value of each month. This gives you an overview of the months in which you had the most liquidity difficulties and those in which you earned the most.

    yearly forecast compared to balance

    You are arrived at the end of the year, so you will now have to re-plan the next one creating a new cash flow forecast, exactly as you have done up to now. Don't stop, only in this way will you see your cash flow improve more and more!

    Help us improve the documentation

    We welcome feedback on how to improve this page.

    Tell us what theme needs a better explanation or how to clarify a topic.

    Share this article: Twitter | Facebook | LinkedIn | Email