When I pull the EFT payments in advance, they show in the current deposit reports

Case example assumptions:

• July 15 is your set of monthly EFT submissions.
• July 13 is the date that you choose to deposit the July 15 EFT payments.
• July 13 is the date that you created the EFT file for the bank.

The EFT payments will show on your deposit reports on July 13th. That will not change. It needs to show that you included the EFT in the current deposit summary.

Theatre Manager can not have those EFT payments automatically show in the July 15 deposit because Theatre Manager has no idea if the EFT file was submitted on time to the bank for July 15, or if the bank accepted/rejected it, or if the EFT file was submitted on July 16, 17, 20, or 30th instead.

If this is a concern, you may want to change the GL Account # associated with the EFT payment method. Instead of having it as “Bank Account-Chequing” (the assumption that it made it into the bank on the same day), change it to have its own account number based on a Clearing Account, or "A/R-EFT Clearing from Bank”. This way, if you want to ensure that GL account for “Bank Account-Chequing” is only updated when the $$ actually processed by the bank, you can monitor the bank statements, and manually create a GL Entry moving the funds from the clearing account to the “Bank Account-Chequing” when the bank has transferred over the funds.

This works in the same manner as Credit Cards. Even though you settle the credit card batch on May 30th, the actual $$ from those credit card sales may not make it to your bank account for 2+/- business days (or whatever your bank merchant agreements indicate). Those credit card payments will appear in Theatre Manager's May 30th deposit, not in the June 2nd deposit reports.