Skip to content
English - United States
Client Support Portal
  • There are no suggestions because the search field is empty.

Why Does My Bulk Cash Receipt Form Start at Row 2 Instead of Row 1?

Learn how row numbering works in the Bulk Cash Receipt Form and what to expect during Cashiering Closeout

What Is the Problem?

You imported a Bulk Cash Receipt file. You noticed one of the following:

  • The first transaction row starts at Row 2 instead of Row 1
  • The transaction order in Cashiering Closeout does not match the order in your original import file
  • Row numbering looks different between older imports and newer ones

This is not an error. It is how the system is designed to work.

Why Does Row Numbering Start at Row 2?

The system reads your Excel file exactly as it is uploaded. This includes the header row at the top of your file.

Row 1 is your header row. It contains column labels like Receipt Date, Amount, and Payment Mode. The system counts this row but does not import it as a transaction.

Because of this, your first actual transaction will appear as Row 2. This is expected behavior.

This design keeps the row numbers in the system aligned with the row numbers in your original Excel file. That way, if you need to trace a transaction back to the source file for an audit, the row numbers will match.

Why Does the Transaction Order Change in Cashiering Closeout?

The Cashiering Closeout process consolidates and posts transactions independently from your original upload sequence. Because of this, the order of transactions in the Closeout may not match the order in your original import file.

This is also expected behavior. The Closeout is not designed to mirror the import file line by line.

How to Restore the Original Import Order

If you need to view transactions in the original upload order, use the Row Number column in the transaction grid.

Click the Row Number column header to sort by row number. This will restore the original sequence from your uploaded file.

What Happens to Deleted Rows?

Deleted rows are not permanently removed from the form. They stay visible, highlighted in red, and keep their original row number. They are excluded from totals and GL postings, but they remain in the form for audit purposes.

This means you can always see what was in the original file, even if a row was removed.

What to Know About Audit Traceability

The system includes several features to support audit review:

  • Row numbers in the system match the row numbers in your original Excel file
  • Deleted rows remain visible and retain their original row number
  • The original Excel import file stays attached to the form after completion and cannot be modified or deleted
  • Sorting by the Row Number column restores the original upload order at any time

These controls are designed to keep your imported data traceable from upload through posting.

Quick Summary

What You See Why It Happens
First transaction starts at Row 2 Row 1 is the header row in your Excel file
Transaction order changes in Cashiering Closeout Closeout processes transactions independently from the import sequence
Deleted rows still visible in red Rows are kept for audit traceability, not permanently removed
Older imports start at Row 1 Row numbering behavior may differ for imports completed before this feature was added

Need Help

If you have questions about row numbering or transaction order in the Bulk Cash Receipt Form, contact the Aclarian Client Support team for assistance.