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.