pioneer

Transcript Study Notes

Upload Process

  • The task of uploading data is discussed as being relatively simple and not time-consuming.
  • Mention of a previous upload from Oklahoma that was not completed last month is briefly referenced.

Reconciliation Issues

  • Importance of matching the numbers between Truvada and checks is emphasized, particularly focusing on the amount $15,420.
  • Challenges arise due to discrepancies between when checks are written and when they are cashed, leading to confusion in matching records.

Trust and Records Management

  • The speaker mentions trusting their records but indicates that filtering by bill payments may help create accurate reconciliations.
  • Discussion about potential outstanding checks and their absence from the Truvada records.

Filtering and Checking Data

  • A proposal is made to filter out bill payments and check records to identify discrepancies and outstanding checks.
  • A discussion on old checks and their statuses is initiated, implying that some voided checks may complicate the financial picture.

Outstanding Checks and Variances

  • Outstanding checks are noted as a primary concern; their absence or incorrect logging in the accounts could lead to inaccurate balances.
  • Mention of variances in balances leads to frustration, as the speaker seeks clarity on financial records.

Need for System Improvements

  • It is suggested that the system of logging checks and bank transactions isn’t adequately maintained, leading to frequent discrepancies.
  • The introduction of additional personnel could help streamline the reconciliation processes.
  • An intention to improve record-keeping through uploads and updates is voiced, specifically regarding checks and payment records.

Analysis of Data

  • The speaker cites a specific instance of records showing $767,838.5 as a transaction total, with a recount indicating a mismatch with previous records.
  • Variances from previous months are noted with specific dollar amounts (e.g., $3,000 last month, $9,000 current month) prompting a need for further checks.

Communication and Team Collaboration

  • Importance of effective communications within the team and proper record log updates, especially regarding checks that have been processed or voided.
  • Discussion reflects on how discrepancies can shift monthly based on outstanding checks and administrative errors concerning record-keeping.

Use of Software Tools

  • Reference to NetSuite for managing checks and transactions, emphasizing its role in keeping track of financial data.
  • Mention of specific tools like 'Positive Pay' to tackle and track issued checks.
  • A noted frustration around the inability to download certain reports or check histories effectively.

Recap of Financial Entries

  • A deep dive into the specific numbers of checks issued (175 for November) and the discussion of identifying discrepancies with prior entries or historical data.
  • The process of thinking through the possibility of issues around voicing checks and the potential errors it introduces to the financials.

Conclusion and Next Actions

  • Acknowledgment of needing to revisit the records with fresh eyes, with planned time for thorough review and corrections.
  • The ultimate goal is to enhance efficiency in financial tracking, minimizing the number of outstanding checks through initiatives like ACH payments.

Recommendations for Processes

  • Increase the use of ACH payments instead of checks to reduce complexity around outstanding records.
  • Strive for better synchronization and tracking within the system to reflect real-time financial status accurately, thus reducing the need for reconciliations.
  • Continuous improvement and regular audits of financial entries, ensuring all checks and payments are accounted for accurately in systems like NetSuite and Truvada.