> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.xap.rocks/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Financial Transactions Report

# Financial Transactions Report



### When would I use this report?

The **Financial Transactions by Transaction date** report will assist you with viewing the **all** transactions per **child**  within the selected date range within your service including:



### Where can you find this report?

1. Select the Reports Screen
2. Under the Financial report section, select the **Financial Transactions (by Transaction Date)** Report
![](https://storage.crisp.chat/users/helpdesk/website/5dcba586b1ba9400/image_1l5hl5h.png)

### What will this report show?

The information displayed on this report includes:

| Column | Heading | Description |
| ---- |
| A | Ledger Account | Displays the ledger details eg. - Revenue, Payment, Liability (bonds) per child |
| B | Provider ID | Displays the ID of the provider the transaction is linked to. |
| C | Debit | Displays any debit charge transactions per child/family. |
| D | Description | Displays the description per transaction type eg. Booking fee,  CCS/ACCS Payment, Gap Discount, Payment, Late Pickup etc. |
| E | Created Date | Displays the created date of each transaction. |
| F | Sessions | Displays the session name of the transactions per child/per payment account linked to the **revenue** ledger. |
| G | Centre ID | Displays the ID of the centre the transaction is linked to. |
| H | Organisation ID | Displays ID of the organisation the transaction is linked to. |
| I | Transaction Category | Displays the name of the Transaction that has been added per child/family account eg. Booking Fee, Direct Deposit, Gap Fee Discount etc. |
| J | Room ID | Displays the Room ID Booking fees and Fee Discounts have been applied against. |
| K | Centre | Displays the name of the centre the transaction is linked to. |
| L | Date | Displays the date the transaction was **created** on. |
| M | Session Reference Code | Displays the session ID code for eg. Booking fee transactions. |
| N | Rooms | Displays the Room/s the transactions for booking fees, fee discounts are linked to. |
| O | Provider | Displays the name of the provider the child is linked to. |
| P | Credit | Displays any credit transactions transactions per payment account. |
| R | Charge Reference Code | Displays the charge ID code for eg. Booking fee transactions. |
| S | Family ID | Displays the Family ID the child is linked to. |
| T | Family | Displays the name of the Family the chid/transaction is linked to. |
| U | Payment Account | Displays the name of the payment account the chid/transaction is linked to. |
| V | Transaction Date | Displays the date the transaction was receipted or added for eg. booking date (can be different to created date). |
| W | Session ID | Displays the ID of the **session** the transaction is linked to. |
| X | Balance | Displays the balance of the transaction entries. |
![](https://storage.crisp.chat/users/helpdesk/website/5dcba586b1ba9400/image_vkye67.png)

### How would I use this report?

The children report can be exported out to **excel** or **csv** formats as well as **filtered**. 

###### Filtering the report

To refine the details listed,
1. Select the **provider** 
2. The **centre/s**
3. Select the **balance as of** date
4. Select the **transactions date from** date
5. Select the **transactions date to** date
6. Select **search** to apply the filters
7. Select the **filter** icon
8. Select the items to include on the report

![](https://storage.crisp.chat/users/helpdesk/website/5dcba586b1ba9400/image_9askpi.png)

###### To export the report,

1. Select the **report type** you would like to view, you can select the report format either **excel** or ** csv**
![](https://storage.crisp.chat/users/helpdesk/website/5dcba586b1ba9400/image_1vuoe29.png)

|| To view all Financial reports see: [Help Page - Financial Reports](https://help.xap.rocks/en/article/help-page-financial-reports-guides-and-videos-12csett/)