Topic · for GOE User, GOE Admin, Admin, Super Admin
Excel templates: export, fill, dry run, import
Every grid round-trips through Excel without losing a cent.
- On a grid, choose Export to Excel. The file is the template: the same columns as the grid with the account code first, and the current figures filled in.
- Fill it in. Amounts are plain numbers with up to two decimal places; leave a cell empty for zero. Do not add or rename columns.
- Choose Import from Excel and run a dry run. Every rejected row is listed with the reason and nothing is written.
- Import only runs when all rows are accepted. The whole file is one save against the ceiling: if the total would exceed it, nothing is written and the message quotes the balance.