Once you have posted any set of line items, payments, and adjustments to a Posting Batch, you can search for and export those transactions by clicking on the Revenue menu and Posted Batches.
Table of Contents
Searching for Transactions
- Select whether you would like to search for Detailed transactions (which returns a row for each separate debit and credit that rolled up into your batch journal entries) or for Journal entries (which returns a row for each Journal entry made to each account - for each day).
Journal entry searches are only available for posting batches completed in the browser, and will not return data for Desktop integration posting batches.
- Fill out any fields by which you want to search. Although none of them are required, a search that returns ALL transactions or journal entries will probably not be very helpful.
You can search by:
- Apply Date start and end date
- Posted Date start and end date
- Accounting Package
- Transaction Type (only available if searching for Detailed Transactions)
- Posting Batch Number
- Account Number
- Click Run This Search.
The results grid will return all matching transactions OR Journal entries depending on your selection.
Exporting Transactions
You can then click Export All Results to send these results to a CSV file.
The export for detailed transactions will include:
- Posting Batch Number
- Apply Date
- Account Number
- Account Name
- Debit Amount
- Credit Amount
- Class Type
- Transaction Code
- Description
- Invoice Number
- Check Number
- Profile Name
- Profile Id
- Date Posted
- Line Item Id
- Payment Id
- Adjustment Id
- Unapplied Payment Id
The export for journal entries will include:
- Posting Batch Number
- Apply Date
- Account Number
- Account Name
- Debit Amount
- Credit Amount
- Memo
- Class Type
- Sent To External System (True or False)
- External Account Id
- Sent Date
- Date Posted