What would be the cause of missing check numbers in the Checkbook Register Report. The report includes Reconciled, Unreconciled, and Voided checks. There are no filters on the report. The check numbers could later be printed, since the missing check numbers were never used. Is there a reason that the sequencing of checks would be off, besides someone manually changing the next check number?
*This post is locked for comments
Hi
In general, the next number sequence for any field works in the same manner.
If you start entering a transaction and decide that you don't want it anymore (for whatever reason) and you delete the transaction, the numbers are still available for use.
However, if you have created a batch of transactions that has already been saved and you then delete a transaction from within the batch (or the entire batch), the next available number won't reset back to the original.
So this scenario could easily have happened:
Entered a batch of 10 manual checks using the default numbering rather than a specific range (started at say check 10). Realised and deleted the batch (hadn't printed anything, so didn't need to void).
Numbers do not reset and next available number is now 20.
Do a check payment batch later on, enter the starting check number as one earlier than the new number but not all the way back to the start e.g. 15 - print the checks without issue as the numbers have not been used. Next available number would now be say 25.
Checks 10 - 14 have never been used.
Hope this helps.
Cheers
Heather
You may need to take all the transactions for a specific check book id, change the sorting criteria to "Filter by Date". Now, even if the numbers have no sequence or have been manually adjusted, all the transactions for this specific checkbook should show on the report.
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (