Exporting a trial balance
Exporting a trial balance
Create a file to export the trial balance from Caselle to use it in Microsoft Excel.
Do this...
1. Open Connect or Clarity General Ledger > Reports > Trial Balance.
2. Set up the report options to choose the trial balance to export.
3. Click to select the Print Settings tab.
4. Click to select the Export checkbox.
5. Click to select the Save As/Export tab.
6. Use the section titled Export Options to enter the File Name.
This is the export file name followed by .csv. To save the export file in the default directory, enter the [filename].csv. To save the export file in a different directory, enter the drive and path followed by the filename, like this: [drive][path][filename].csv or c:\desktop\TrialBalanceYYYY.csv
7. Click Print (CTRL+P).
The trial balance is saved as a file that you can open in Microsoft Excel.
Related Articles
Finance Worksheet for Audit Export
The report definition is also attached. It can be loaded by downloading it. Then logging into Connect, going to System Management – System Tools – Import Report Forms/Definitions. Click the Browse button and search out to your download folder (or ...Balancing Accounts Payable for Audit
At the beginning of our fiscal year, many of us switch to recording invoices under an accrual basis of accounting. You may ask what "accrual" even means. It means that you charge the invoice to the year in which goods or services were received or ...Audit Checklist
To download a checklist, right-click on the links below and select Save link as or something similar. Then, save the checklist to a location on your computer or network. When the Download compete screen appears, click Close. Open the Connect program. ...Create a Finance Worksheet for Audit Export
See AttachmentExcel Functions and Functionality to Manipulate Data
See attachment