Cash Accounting: Bank Transfer Journal Entries Report

The Bank Transfer Journal Entries Report in our Cash Accounting Analytics shows you all-time deposited funds in your account through LeagueApps Gateway across your entire organization. You can then export this report to create bank transfer journal entries in your accounting software.

If you only have one site in your organization, it will just display that site’s data. 

This report is meant to work in conjunction with either the Individual Journal Entries Report or the Summary Journal Entries Report by creating a separate journal entry for deposits. There are always two lines in a bank transfer journal entry: (1) one representing the undeposited funds as total net amount for the bank transfer Id, and (2) one representing that total net amount getting debited to the bank account.

If your LeagueApps Gateway account is set up at the organization level, and you're viewing this report across your entire organization, you may have more than two lines in a journal entry. There will be one line for undeposited funds and one line for the bank account per site that's part of the bank transfer.

Table of Contents 

• Navigation & Filtering
• Bank Transfer Journal Entries
• Exporting & Scheduling

Navigation & Filtering

To view this report, navigate to the Reporting icon and select Reports option under the Analytics header. Then, navigate to the left sidebar, and select Bank Transfer Journal Entries under the Cash Accounting section. 

You can filter the data by selecting options from the filters at the top of the report. Selecting options within these filters will change the data you’re seeing for the chart in this report:

• Site Name
• Journal Date
• Journal Number

Any of the columns can be sorted by selecting the arrow in the column title, and choosing which sort option you would like to use.

Bank Transfer Journal Entries

In the chart, you are able to view all bank transfer journal entries based on the filters you chose at the top of the report. Below is a sample bank transfer journal entry, as well as a definition for each field:

• Journal Number is the Bank Transfer Date - D - Last 9 Characters of Bank Transfer Id # (the D stands for “Deposited”)
  • In the above example, the bank transfer date is 02/12/2023, and the last 9 characters of the bank transfer Id are “0U3lAmQAj” 
  • The date is formatted MMDDYYYY
• Journal Date is the date of the bank transfer
  • In the above example, the bank transfer date is 02/12/2023
  • The date is formatted MM/DD/YYYY
• There are two lines in the journal entry: one representing the undeposited funds account and one representing the bank account
  • Undeposited Funds line: the Account is always “Undeposited Funds”. The Amount is the net amount from all transactions in the bank transfer Id, and it’s credited to the account (so it’s negative)
    • In the above example, the amount is -$370.43, credited to Undeposited Funds
  • Bank Account line: the Account is always “Bank Account”. The Amount is the net amount from all transactions in the bank transfer Id, and it’s debited to the account (so it’s positive)
    • In the above example, the amount is $370.43, debited to Bank Account
  • Note: if the total bank transfer amount was negative (i.e. in the case of many refunds being processed at once), the Undeposited Funds line would be positive, and the Bank Account line would be negative
• Description is always “Bank Transfer Journal Entry”
  • In the above example, the description is “Bank Transfer Journal Entry”
• Class is always blank for bank transfer journal entries 
  • In the above example, the class for both lines is empty (or “null”)
• Memo is the Bank Transfer Date - Bank Transfer Id 
  • In the above example, the memo for both lines is the bank transfer date (02-12-2023) - bank transfer Id (po_1MaqaeLQtmEY0A00U3lAmQAj)
  • The bank transfer date is formatted MM-DD-YYYY
• Name, also considered the Customer, will always equal “LeagueApps”
  • In the above example, the name for both lines is “LeagueApps”
• Site Id is the LeagueApps site Id where this bank transfer was created
  • In the above example, the site Id is 42061
• Site Name is the LeagueApps site name where this bank transfer was created
  • In the above example, the site name is “Seattle Sea Lions Demo”
• Org Account Id is the LeagueApps organization account Id where this bank transfer was created
  • In the above example, the org account Id is 17808
• Org Account Name is the organization account name where this bank transfer was created
• In the above example, the org account name is “LeagueApps Demo Environment”

Exporting, Bookmarks, Sending, & Scheduling

The chart can be exported or filtered by hovering over the top right corner of the chart and selecting your desired options.

If you added any filters to customize this report to your needs, you can save that filtered report as a bookmark so that you are able to access it in the future. You can bookmark the report by clicking the bookmark dropdown in the bottom right of the report and selecting Save as new bookmark.

You can also save one of your Bookmarks as the default, so that bookmarked filtered report that will open when you navigate to that specific Analytics report.

Any report or dashboard from LeagueApps Analytics can be exported by selecting the three horizontal lines in the bottom left corner of the screen, and then selecting Schedule export or Send now. You can choose to schedule exports at specific days and times, and with specific conditions (e.g. only if new data has occurred),

You can then choose email addresses—whether they’re part of your organization or not—to send it to, and the cadence you would like the export to occur at. Depending on the report or dashboard, you can export the data as CSV, Excel, or PDF. 

Click here to learn about the other reports available in LeagueApps Analytics.