In financial processes, voucher numbering and preventing duplicate payments are often regarded as two basic controls. However, when the accounting system in use has limited functionality, it may be difficult to achieve both simultaneously. A user working in an organization that uses QuickBooks (desktop version) encountered such a practical dilemma.

The organization's expenses are carried on vouchers, and sequential numbers are assigned to each voucher by stamping. QuickBooks desktop version, when entering bills, only provides two free-text fields: "reference number" and "memo", and the system only performs duplicate checks on the reference number, while the memo field allows arbitrary content without any duplicate-checking mechanism.

Currently, the organization's practice is to fill the voucher number into the reference number field and record the supplier invoice number in the memo. The user questions this arrangement: it cannot effectively block the same invoice from being submitted and paid twice—because the system only checks for duplicates on the voucher number, which is inherently unique, and duplicate invoice numbers do not trigger any warning. In other words, the current process has a clear loophole in preventing duplicate payments.

The user is well aware that sequentially numbering vouchers is one of the recognized best practices in internal control. But given that QuickBooks does not support adding custom fields to record both the voucher number and the invoice number simultaneously, he must make a trade-off between "preserving voucher numbering" and "ensuring invoices are not paid twice". Therefore, he seeks advice from peers: in this situation, what is the best internal control practice? Is voucher numbering indispensable, or can it be abandoned?

Core issue: control conflict under system limitations

The core contradiction in this case is that QuickBooks desktop version only allows one reference field that can be checked for duplicates, while the organization needs to track two separate identifiers—the internal voucher number and the external supplier invoice number. Since both cannot be entered and checked for duplicates at the same time, the organization has to sacrifice one of the controls.

From an internal control perspective, voucher numbering is mainly used to ensure that all expenditures are documented and sequentially complete, facilitating audit trails; whereas invoice number duplicate-checking directly prevents the same accounts payable from being entered and paid twice. When resources are limited, the latter often has higher priority in risk prevention and control, because duplicate payments directly lead to financial loss.

Possible alternative solutions

Although QuickBooks does not support custom fields, the user can still adjust the process to accommodate both controls. The following suggestions are based on common practices and are for reference:

  • Enter the invoice number into the reference number field: Use the system's duplicate-checking function on the reference number to directly block duplicate invoices. The voucher number can be moved to the memo field, or retained through external numbering (such as a stamp on the paper voucher), but this relies on manual verification.
  • Enable the "Bill Number" feature: In QuickBooks, when entering bills, if the "Bill Number" option is enabled in Settings, the system will automatically generate a unique number for each bill and allow entry of the supplier invoice number. In this case, the reference number field can be filled with the invoice number, and the system-generated bill number serves as the internal voucher number, with both being checkable for duplicates (bill numbers are automatically unique, and invoice numbers can be checked for duplicates).
  • Use the "Inventory" or "Item" field as a workaround: If the organization does not deal with inventory, the "Inventory Number" or "Item" field can be used as a second identifier, but note that these fields may not participate in bill duplicate-checking and only serve as auxiliary records.
  • Standardize voucher number recording in the memo: If the voucher number must be retained, it can be written into the memo in a unified format (e.g., "V-2023-001"), and before payment, manually check whether the voucher numbers in the memo are duplicated, or periodically export bill reports for verification.

Is voucher numbering indispensable?

From an audit and internal control perspective, voucher numbering is not absolutely mandatory; its core purpose is to ensure that every expenditure is traceable and complete. If the system can automatically generate unique bill numbers (such as QuickBooks' bill number feature), the absence of internal voucher numbers can be compensated by system-generated numbers. However, if the organization relies on paper voucher circulation, stamped numbering remains part of physical control and should not be easily abolished.

When both controls cannot be satisfied simultaneously, it is recommended to prioritize preventing duplicate payments, because the consequences of failure are direct and severe. Voucher numbering can be equivalently controlled through other means, such as system-generated numbering or external ledgers.

"Best practices are not static; they involve trade-offs based on system capabilities and risk exposure. In the QuickBooks environment, leveraging its built-in bill numbering feature may be the optimal solution to this conflict."

In summary, the organization should assess the degree of automation in its processes and its risk tolerance. If the QuickBooks version supports bill numbering, it is recommended to enable it immediately and fill the supplier invoice number into the reference number field to achieve dual control. If it cannot be enabled, more resources need to be invested in manual review and process design to compensate for system limitations.