Questions? We have answers.

CivicView: General Ledger Export

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn about the process of exporting a General Ledger file from CivicView.


Configuration Details

Using the Export Utilities, export the (batch) transactions for your desired audit period.

 

Note: Before importing into Excel, open the file in Text Editor and change the first line to remove the text string that appears in the first row of data. This can be done to the export Excel file as well.  

After importing the text file into Excel, perform the following actions:

  • Insert a new row 1, which includes the MindBridge required columns.
  • Change column J (Amount) so the formatting is #,###.00.
  • Apply a filter to Column A to only show Control Acc (Ledger Acc) and not the full account number.

The exported report should look like this:

CivicView exported file example

 


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


 

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.