BUSY Accounting Software sends one report at a time to Excel.
Open the report, press Alt+E and choose Excel. Its help says the entire dataset cannot be exported in one command. For a full financial year, repeat the export for each report or use a converter that reads the company folder and writes every table to one workbook.
You asked for everything and the program handed you one report. That is how the built-in export works. A year of books means a day book, ledgers, stock and outstanding balances, each exported by hand. This guide shows how the export behaves, where it stops and how to get a whole year into a spreadsheet.
Why Can't BUSY Export All Data to Excel in One Command?
The program builds its Excel file from the report that is open on the screen. You get what that report shows and nothing more. The vendor's help states that the whole dataset cannot be exported to Excel with a single command, and it points users to individual reports.
For a full year of books that adds up. You need the day book, the ledgers, stock, outstanding balances and more. Each one is a separate export with its own dates and filters. It is easy to forget one, and you will only find out when the auditor asks for it.
“BUSY already exports one report at a time. The gap is a whole year in one go, and that is the gap our converter is built to close.”
Which of these describes your job?
The built-in export is enough. Open the report, press Alt+E and choose Excel.
See the Alt+E steps →A year means every table in one workbook. A converter that reads the company folder does that in one run.
Export a full year →That file is meant for moving data between BUSY installations. It is not a spreadsheet.
Read what XML does →How to Export a BUSY Report to Excel With Alt+E
These steps use the vendor's own example, the Sales Register. Any other report works the same way once it is open on the screen.
- Open the reportGo to Display, then Account Books and Account Registers, and choose Sales Register. Pick the sales type, the parties and the date range, then click OK.
- Press Alt+EWith the report on the screen, press Alt+E or click the export button.
- Choose ExcelSelect Microsoft Excel as the format. Excel and PDF are among the choices.
- Name the filePick a file name and a folder, then click OK. Open the file in Excel to check it.
- Repeat for every reportEach report needs its own export. Write down the list so that nothing is skipped.
A voucher list exports the same way. Open the list, press Alt+E and choose Excel. If the Excel export fails, the vendor's help says to check that BUSY and Excel are installed on the same drive. If a PDF export fails, antivirus software may be blocking BUSY, so add the program to its exception list.
What Does the BUSY XML Export Do?
It writes XML files and not spreadsheets. Open Administration, then Data Export Import and the XML option. Choose Masters or Transactions and pick the types. Then set the period and the folder, and click Export. The vendor's help adds that this export is not available in BUSY Basic and needs the Standard or Enterprise model.
The vendor describes the XML route as a way to move data between BUSY installations. It does not produce a workbook. The same menu also holds the import side, which loads vouchers and masters from Excel into BUSY. That is the opposite direction from this guide.
How to Export a Full BUSY Financial Year to Excel in One Run
Univik BUSY Data Converter belongs to Univik BUSY Data Recovery Toolkit. It opens the .bds files of a company folder and writes one financial year to a single Excel workbook. The work happens offline and the source files stay untouched.
- Copy the company folderCopy the company folder, such as COMP0001, to a local drive. The export reads the copy and leaves your original folder alone.
- Install the toolkit and open the folderInstall Univik BUSY Data Recovery Toolkit on Windows 11 or 10 and open the company folder. BUSY does not have to be on the PC.
- Choose the exportOpen Export and pick Everything in Excel.
- Set the filtersLeave the From and To dates empty to take the whole financial year, or set a range. Keep sales, purchases or other vouchers as you need. Tick the option to include deleted vouchers only if you want them.
- Pick a folder and startChoose where the workbook should be saved. The file name carries the company and the year.
- Read the row countsWhen the run ends, the software lists the rows written for each table. With no filters set, it warns you if a count differs from the file.
A Summary sheet comes first. After it you get sheets for accounts and items. Further sheets hold the vouchers with their entries and item lines. The last ones cover bill sundries and bill references. When the company file carries audit records, two more sheets hold the audit trail and the activity log. Vouchers that BUSY deleted but the file still held show as amber rows with a Status column.
The same export screen offers CSV files with one file per table, one JSON file, invoices as PDF and five PDF reports. Each run covers a single company and a single financial year, so five years of books need five runs. The converter page lists every output.
Univik BUSY Data Converter reads the company folder and lists the rows written for every table, so you can tie the workbook back to the books.
Download Free Trial Buy Now - $99Needs Windows 11 or 10. The trial writes the first ten items of each section. Personal is $99 for two PCs, with a 30-day money-back promise. Converter page
Which Way Should You Use to Export BUSY Data?
Pick by how much data you need and whether BUSY is on the PC.
| Way | Scope | Needs BUSY | Output | Watch for |
|---|---|---|---|---|
| Alt+E on a report | One report | Yes | Excel, PDF and other formats BUSY lists | Repeat for every report |
| Alt+E on a voucher list | One voucher list | Yes | Excel | Only the list you opened |
| XML export | Masters or transactions | Yes, Standard or Enterprise | XML files | Not a workbook |
| Univik BUSY Data Converter | One company, one financial year per run | No | Excel, CSV, JSON and PDF | Saving needs a licence. Trial: 10 items per section |
Which Reports Should You Export First If You Stay Inside BUSY?
Start with the reports an accountant uses to prove the rest. Export the day book first, because it lists the vouchers by date. Add the ledgers of your main parties, then the trial balance, the stock report and the outstanding balances. With those five in Excel you can tie the totals before you chase smaller reports.
How Do You Check an Excel Export Against the Books?
- The voucher count in the workbook matches the count you see in the program for the same dates
- Total debits equal total credits
- The trial balance in Excel matches the printed trial balance
- A few party balances match the ledger on the screen
- The date range in the file name or the Summary sheet is the one you meant
Fix Common Problems When You Export BUSY Data
Do this: The vendor's help says to check that BUSY and Excel are installed on the same drive. For a PDF that fails, check whether antivirus software is blocking BUSY.
Do this: An export holds what the report shows, so check the date range and the filters first. The vendor's help also lists a different company and missing user rights as reasons that vouchers do not show.
Do this: The steps for a missing company are in our fix guide. A viewer can read the folder when the program will not list the company.
Need help choosing an output for your auditor or a reporting tool? Contact our support team and tell us what the file has to feed.
Questions About Exporting BUSY Data to Excel
The Univik team helped check this guide. We checked the Alt+E steps, the XML limits and the one-command limit against the vendor's help on October 11, 2026. The workbook details follow the converter page, built from Leena's tests on BUSY 21 folders.
Pages we read: the Excel export answer · the import and export answer · the voucher export answers · the XML answer