Use the GL Writeback feature to create allocations, accruals, and many other types of GL entries such as:
- Month-end allocations of revenue and expenses
- Accrual transactions
- Release of restricted funds
- Fringe calculations
- Inter-entity and multi-currency transactions
- Calculations, or GL entries that depend on data that is not available in your ERP
Create a Journal Transaction Worksheet
From any spreadsheet, start by creating an empty GL entry worksheet. In the Velixo ribbon, click GL Writeback pulldown and then select New Journal Transactions Worksheet.
A spreadsheet template will open that looks is similar to the Journal Transactions page.
For each row, enter data that is necessary for your journal entry. Velixo will ensure that any cells you leave empty will populate with default values (as they would when entering the transaction manually from your web browser).
Next, click on GL Writeback pulldown, again, but this time select Import Current Worksheet.
Velixo will apply validation rules and present errors for any entry that is out of balance or uses an invalid GL account.
Watch the video below to see how easy it is to import the spreadsheet into your ERP. In the video, notice that we allocate expenses for a shared call center—based on the revenue of each of its branches. The calculations leverage many of the functions that Velixo adds to Excel, including ACCOUNTTURNOVER(), ACCOUNTTOTALDEBITS() and ACCOUNTTOTALCREDITS().
You can also use standard Excel functions and reference other cells in your workbook.
The description of our journal entry is dynamic and varies with the current month and year. Remember that formulas can be used anywhere!
Use your journal entry spreadsheets as templates, and import them weekly or monthly. Optionally, you can create an Excel workbook file that contains as many journal-entry template worksheets as you like.