Neste artigo
In Banana Accounting various functions are available to manage the Suppliers register in a simple and optimal way. The supplier master data can be set both in double-entry accounting (also with VAT and Multi-currency) and in the Cash Manager (Categories table) and in the Income / Expense accounting. This flexibility allows all users to manage suppliers for any type of accounting.
The settings of the supplier master data include both the management of the turnover and that of the collected. You can also manage supplier accounts in foreign currencies.
Similar to Excel
Banana Accounting is based on tables like in Excel, but everything is set up for accounting and there is no need to enter formulas or make calculations.
- All supplier data you enter in the tables are always visible and at your fingertips.
- You work quickly because you can select, copy and paste, across multiple cells and multiple rows.
- If you make a mistake, you can correct by canceling or redoing the operations.
- Add as many rows as you want without limits, or delete rows you don't need.
- With the Find and Replace function, correct in an instant
- You don't need to enter formulas because the calculations are updated immediately and you have a contextual view (like in spreadsheets).
- You can print everything you see on the screen or export it to PDF or other formats.
- You can set your company logo to customize the print headers.
- The columns are customizable, you can change their position, add new ones and change their width.
- Work with the format that suits you best.
- Color the lines to rapidly locate the supplier records you need to review, have the accountant check, or complete.
Based on tables
The settings and all supplier transactions are available in the following tables:
- Accounts table
In this table, at the end of the chart of accounts, you can set up all the accounts of the suppliers, enter the opening balances (without having to manually enter them in the Transactions table). You can group multiple accounts together to have the totals of the distinct amounts, such as a group to total national suppliers and a group to total foreign ones, or you can group them according to the category of goods or services sold. In the accounts table you can see at a glance the updated balances for each supplier and the total balances,- Set up a national, international or free grouping scheme of your suppliers.
- Manage supplier addresses, with predefined columns that can be customized in the view.
- Enter the credit limit granted by the supplier.
- Enter the number of days within which payment must be made.
- Enter the balances directly in the Opening column of the Accounts table and only the first time you use Banana Accounting.
In subsequent years, the carryover is automatic.
- Transactions table
This is the table where all supplier movements are recorded, as well as all other movements of a different nature. You can insert digital documents (for example the invoice issued by the supplier, or annotations in pdf). To quickly post the receipts, you can import them from your bank, postal or credit card account. Scrolling the table you have a complete view of all the events. You can modify and correct to always have perfect accounting.- You can insert single or composite Transactions.
The single ones register them on a single line, while the composite ones allow you to easily record transactions that affect multiple accounts or that have different VAT rates. - You can register with the Turnover Method or the Cash Method.
- When you register, you are offered the texts already entered. One click is enough to complete the registration (auto-completion).
- Quantity and price columns, for invoicing or cost control.
- You can insert single or composite Transactions.
Additional tables that can be added that support additional functionality.
- Budget table
- Used to prepare financial forecasts. You can enter the forecasts of your suppliers and have the liquidity projection in an instant.
- VAT Code table
To set up the necessary rates and parameters to be used in the Transactions table for automatic VAT calculation and reports to be submitted to the tax authorities. - Free tables
- To meet further needs
Accounting setup
Banana Accounting provides Plan of Accounts templates with pre-defined supplier ledger settings.
There are two categories of templates:
- Templates with the turnover ledger.
- Templates with the ledger on the cash method (with cost centers).
Just open the template and customize it, inserting your own accounts, changing the description or deleting unneeded accounts and you can immediately go to the registration of movements.
Financial budget
- If you need to create a budget you can activate the function by adding the Budget table.
- You work without difficulty with the same methodology you are already used to, based on the double entry method.
- Complete and detailed financial forecasts of your suppliers.
- Forecasts of your suppliers in the financial statements.
- Automatic projections for several years.
- Forecast values available in accounting printouts:
- Account card with forecast movements by account or group of your suppliers.
-
In addition to accounting, you can set your forecasts with supplier management, using the powerful management approach Plan - Execute - Control.
Balance sheet
- Reports with final data and budgets with indication of the differences of the suppliers.
- Free arrangement with groups and subgroups.
- Updated results visible directly in the accounts table.
- Customizable prints:
- Add your own logo.
- Choice of columns to include.
- Choice of sections to include.
- Detailed or grouped print.
- Prints for one period only.
- Columns broken down by period (month, quarter, semester, year).
- Previous year values.
- Comparison Budget Value.
- Columns with subdivision by segment.
- Added notes attached.
- Grouping as in the chart of accounts or according to its own scheme.
- Saving the customization.
- Tabular report (similar to customizable printouts, but with the data present in the table).
- Export to pdf for data storage and export to other formats for data re-processing.
Other accounting printouts
- Table contents completely printable or also printed by selection only.
- Add your own logo for customization of your suppliers' documents and prints.
- Journal.
- Cards with account movements and groups of your suppliers:
- With accounting or budget transactions.
- By period.
- By Account, Group, Cost Center or Segment.
- Accounting or budget data.
- Customizable column arrangement.
- Export to pdf or other formats.
Charts
- Contextual, at the bottom of the table.
- Several provisions.
- Evolution of accounts and groups.
- Accounting values.
- Budget.
- Previous year.
- Choice of chart type.
Supplier control
- Check invoices and payment to suppliers.
- Open invoices by supplier
Supplier movement account statement and still open invoices. - Automatic reconciliation, open invoices.
Closing and new year
- Automated procedure to create the new year file.
- Carryover of balances into the new year
- You can start working on the new year, even if the previous one has not closed.
- Command to resume definitive balances when the previous year was closed.
Data export and storage
- Copy and paste directly to and from Excel.
- Export tables in pdf and various other formats.
- Archiving of printouts and accounting data in pdf or other formats.
- Saving of the accounting file on any support.
Documents table
Other Additional Tables
- Adding other tables where you can enter notes or other information.
- Tables can be customized by adding columns to them.
Comprehensive documentation
- Each dialog and error has its own documentation page accessible with one click.
- Constantly updated documentation.
- Questions and answers.
- Documentation also available in PDF format.