Skip to content

Deposit Report Development

VIDEO TRANSCRIPT | Recorded: 2025-09-26 | Verify against current system state

Abstract

Technical meeting with I2C development team regarding Salesforce deposit report enhancements for bank reconciliation. Discussion covers requirements for GL account subtotals, credit card type filtering (separating Amex from other cards), timestamp filters, order line adjustments, and export functionality for Intacct journal entry import. Team works through report block limitations and identifies path forward using deposit report without orders as base template.

Key Procedures

  • Use deposit report without order as base template for cleaner GL grouping
  • Filter by gateway date timestamp for daily reconciliation
  • Filter by credit card type to separate Amex from Visa/MC/Discover
  • Group and subtotal by GL account code for Intacct import
  • Export report to Excel with summary rows for copy/paste to journal entry
  • Verify order line adjustments (not cancellations) appear in total price
  • Compare Salesforce data against Aptify and bank statements for reconciliation
  • Drill into individual orders to find token when researching discrepancies

Notable Statements

  • 0:01:35 "We need to be able to have a subtotal of the GL account. That one's going to be pretty important for us."
  • 0:02:43 "Amex doesn't get processed with the other credit cards."
  • 0:05:13 "The only thing that we need when we're going to enter the information into Intacct is the subtotal by GL account."
  • 0:06:35 "We can't do both in one report" - Re: detail view vs summary export
  • 0:08:27 "This report was going in the right direction... the group by GL level when I remove the detail rows."
  • 0:15:10 "Once we do more testing, then I would know if I really need to drill in or not."
  • 0:17:03 "The cancellations, Jeff is still working on it."
  • 0:23:54 "Once I can do more testing... things kind of match up."

Systems & Configurations

Systems Mentioned

  • Salesforce (report development, order management)
  • Intacct (financial system, journal entry import)
  • Aptify (legacy system for comparison testing)
  • BluePay (payment gateway)
  • RightRev (revenue recognition)

Specific Configurations

Item Value/Setting Timestamp Notes
Test Data Range Jan 2023 - March 2023 0:22:05 Historical import data
Additional Range May 2023 - July 2023 0:22:32 More test data available
GL Dimension Code 9999 0:27:12 Standard membership
Auto Renewal GL Different 4 digits 0:27:44 Separate from standard
Report Status Filter Activated (not cancelled) 0:21:09 Orders included

Credentials/Access Mentioned

  • Salesforce report access for finance team
  • Teams chat for finance migration communications

Errors & Troubleshooting

  • Issue: Two report blocks required for all data
  • Cause: Token/gateway fields live in different block than GL data
  • Resolution: Use deposit report without order for primary needs; separate lookup report for token research

  • Timestamp: 0:03:35

  • Issue: Cancellations not appearing in reports

  • Cause: Data import script not yet including cancelled orders
  • Resolution: Jeff working on adding cancellation support to import

  • Timestamp: 0:16:57

  • Issue: Auto renewal GL code mismatch with RightRev

  • Cause: Auto renewal comes as order adjustment in Salesforce but separate product in historical
  • Resolution: May need to adjust deferred revenue GL in RightRev
  • Timestamp: 0:27:00

Transcript Gaps & Quality Notes

  • Multiple speakers from finance team (Randall, Leida, Amanda) and I2C (Archie)
  • Meeting focused on iterative report refinement
  • Credit card type filter identified as critical requirement
  • Follow-up scheduled for Tuesday to review updates
  • Cancellations blocking full testing - dependent on Jeff's import work