A $200 hotel reservation shows up as ‘pending’ on the credit card. The available credit drops by $200. Two days later, the actual charge posts for $185 (the room rate, not the hold amount). The Excel conversion will only see the posted charge of $185, not the $200 hold. A user notices their available credit is $200 less than expected.
Looking at the statement, no $200 charge is visible. The auth hold is reducing available credit but has not yet posted.
TL;DR. An authorization hold (auth hold) is a pending charge that reserves credit before the merchant submits the actual transaction. The 3 states: auth hold, pending, posted. The Excel conversion only sees posted transactions. The auth hold is invisible to the converter.
For the broader credit card to Excel workflow, see the credit card to Excel guide.
What an Authorization Hold Is
An authorization hold (auth hold) is a temporary reservation of credit on a credit card. The merchant requests the hold when the card is presented, before the final transaction amount is known. The hold reduces the cardholder’s available credit immediately, but the actual charge is not yet on the statement.
What most guides miss about credit card statements is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.
Auth holds exist to protect the merchant from fraud and from insufficient funds. When a hotel pre-authorizes $200 for incidentals, the hold ensures the cardholder has $200 of available credit when the final bill is calculated. When a gas station pre-authorizes $1, the hold ensures the card is valid before the pump is enabled.
The 3 States of a Transaction
A credit card transaction has 3 states, each visible at a different point in the process. The Excel conversion sees only the final state.
State 1: Authorization hold (reserved)
The merchant has requested the hold. The card network has approved it. The cardholder’s available credit is reduced. The transaction is not yet submitted for settlement. This state is invisible on the statement but visible in the issuer’s online portal as a ‘pending’ transaction.
State 2: Pending (submitted, not yet posted)
The merchant has submitted the transaction for settlement. The card network has accepted it. The transaction is in the processing queue. It may still show as ‘pending’ on the issuer’s website. The Excel conversion does not see it yet.
State 3: Posted (final, on the statement)
The transaction has settled. The charge is final. It appears on the credit card statement. This is the only state visible to the Excel converter. The available credit is now updated to reflect both the new charge and any payment activity.


Turn That PDF Into a Spreadsheet in Minutes
You've seen how to do it manually — now let the tool handle the heavy lifting. Upload your bank statement and get Excel, CSV, or QBO in a few clicks.
Try It FreeHow Long Auth Holds Last
Auth holds have different durations depending on the merchant type and the card network rules. Most holds release within 1 to 7 days. Some merchant types have longer hold periods.
| Merchant type | Typical hold duration | Notes |
|---|---|---|
| Restaurants | 1 to 3 days | Tip adjustment may extend hold |
| Gas stations | 1 to 3 days | Pre-auth typically $1, final charge higher |
| Hotels | Up to 30 days | Hold covers room rate plus incidentals |
| Rental cars | Up to 30 days | Hold covers rental plus potential damages |
| Online retailers | 1 to 7 days | Most release within 1 to 3 days |
| Subscription services | 1 to 3 days | Recurring charges may have shorter holds |
Why the Auth Hold Amount May Differ from the Final Charge
Auth holds do not always match the final charge. Three common scenarios illustrate this.
Scenario 1: Gas station pre-authorization
A gas station pre-authorizes $1 when the card is inserted. The cardholder pumps $45 of fuel. The final charge is $45. The $1 hold releases within 1 to 3 days. The Excel file shows $45, not $1.
Scenario 2: Hotel incidentals hold
A hotel pre-authorizes $200 per night for incidentals (room service, minibar, damages). The cardholder stays 3 nights. The total hold is $600. The final bill is $185 per night ($555 total). The hold releases after checkout, but the $600 was reducing available credit the entire stay.
Scenario 3: Restaurant tip adjustment
A restaurant charges $50 for the meal. The auth hold is $50. The cardholder adds a $10 tip. The final charge is $60. The auth hold adjusts to $60 when the tip is added. The Excel file shows $60.
The Excel and Reconciliation Impact
The Excel conversion only sees posted transactions. The auth hold is invisible. This creates a reconciliation gap: the available credit is lower than the Excel balance suggests, because the auth hold is reducing available credit without showing on the statement.
A common failure mode bookkeepers report is the auth hold causing reconciliation issues. The Excel file shows the final charge, but the cardholder’s available credit reflects the hold amount. The two don’t match until the hold clears.
How to See Auth Holds in the Issuer’s Portal
The issuer’s online portal or mobile app shows pending transactions, including auth holds. The portal typically shows a ‘pending’ section or a ‘pending transactions’ tab. The hold amount and the merchant name are visible, but the final charge amount is not yet known.
For Excel conversion, the pending transactions are not relevant. The Excel file shows posted transactions only. The pending transactions are a separate data source, accessed through the issuer’s portal, not through the PDF statement.
For the broader credit card statement workflow, see the credit card to Excel guide. For the parent pillar, see the credit card conversion guide.
For a deeper understanding, see: credit card statement pillar. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.
Turn That PDF Into a Spreadsheet in Minutes
You've seen how to do it manually — now let the tool handle the heavy lifting. Upload your bank statement and get Excel, CSV, or QBO in a few clicks.
Try It Free







