Changes to Netsuite Files: Related to Bank Reconciliation

1. We had originally configured the report to lump payment types by date. Due to timing from time to time, a payment batch can straddle two days. Is it possible for ACH and Credit Card payment types to compress if the batch numbers are the same. Below is an example of our current export, if we could have the 947.81+3751.12 (Credit Card) compress to be a total on one line. Likewise same with 1377+400 (ach). The later date would be preferred. This change would only need to be for the Netsuite GL Report.

Example below of current export.

Propose New

2. Second change is for the Third Party Payment lines. Before it was not an issue, as Canada only had 1 agency per region. But as we move into the US, they have multiple agencies. Current export is below and we would like to add the Agency name and Authorization Number (check number). If the character lines number is too long, please drop the 710002. This change would only need to be for the Netsuite GL Report, nice to have the Netsuite Subledger Report updated.

Current Line Memo: 710002 - Third Party Payments - HOD – DCWT

Proposed New: 710002 - Third Party Payments - HOD – DCWT – Depart. Of Veteran Affairs (or its Agency Identifier Name) - 29933131