Exporting a trial balance

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

    • Tax Certification - Utility Balance Adjustment - Video

      Utility Balance Adjustment
    • Ending balance does not match beginning balance (Checkout error)

      If you receive a Checkout error indicating that the ending balance for an account does not match its beginning balance, follow these steps to correct this issue: 1.  Open General Ledger > Organization > Recompute Beginning Balances. 2. Click GO. ...
    • Fund out of balance (Checkout error)

      If you receive a Checkout error indicating that you have funds that are out of balance, follow these steps to correct this issue: 1.  In the General Ledger, go to Journals > Create Allocations. 2. Verify the Period is set to the proper month. 3. ...
    • miViewPoint User Guide

      Other miViewPoint User Guide This manual has been prepared by Civic Systems for use by customers and licensees of Civic and Caselle software. Information in this document is subject to change without notice. The software described in this document is ...
    • miExcel Disappeared

      If miExcel has disappeared from Excel the first thing to do is to check and see if the add is just disabled.  To do this follow the steps below: 1. Launch Excel 2. Click File -> Options 3. Click Add-ins 4. Check to see if miExcel is showing in the ...