Corporate Credit Transaction Examples
This page contains examples of different types of Corporate Credit (CC) transactions. For an explanation of real-time funding see About Corporate Credit. Also see About Card Transactions.
These examples show the entries that are written to the ledger for different transaction types. The tables combine the activity for both the CC funding and CC spending accounts. For all examples the following is true:
- 4444444 — PRN of the CC funding account
- 7777777 — PRN of the CC spending account
- The
source_id
for all adjustments refers to theadj_id
in the adjustments table. - The CC funding account has a 1000.00 credit limit.
- The CC spending account contains 0.00 as a beginning balance.
Examples
- Conventional purchase
- Reversal without settlement
- Reversal with settlement
- Merchant credit (Maestro)
- Merchant credit (Mastercard credit)
- Gas pump
- Incremental authorization
- Partial reversal on authorization
- Incremental clearing
Conventional purchase
A Mastercard cardholder makes a $35 purchase on 13 Jul 2023 at 9:00 am.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-07-13 09:00:00 | ADFY | -35 | 4444444 | 555444 | 333666 | -35 |
2 | 2023-07-13 09:00:00 | ADSY | 35 | 7777777 | 555444 | 333667 | 35 |
3 | 2023-07-13 09:00:00 | AUA | -35 | 7777777 | 555444 | 555444 | 0 |
4 | 2023-07-15 07:31:22 | BO5 | 35 | 7777777 | None | 555444 | 35 |
5 | 2023-07-15 07:31:22 | SE5 | -35 | 7777777 | 555444 | 555444 | 0 |
- Row 1 — The transfer out of the CC funding account. The
source_id
refers to the entry in the adjustments table (adj_id
). - Row 2 — The transfer into the CC spending account.
- Row 3 — The approved authorization amount. A 35.00 hold is placed on the CC spending account, so the available balance is 0.00. Between the time that the 35.00 is moved into the CC spending account and the hold is placed, the amount is locked, so the 35.00 cannot be spent by another process.
- Rows 4–5 — The settlement time, when the authorization hold is backed out and the settlement is posted to the CC spending account.
For instructions on simulating this type of transaction see Perform transactions in Testing Corporate Credit.
Reversal without settlement
The cardholder makes a $45 purchase on 12 Aug 2023 at 8:00 pm, and it is reversed an hour later. The reversal happens before the transaction clears, so there is no settlement. The network is Visa. Most authorization reversals follow this pattern.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-08-23 20:00:00 | ADFY | -45 | 4444444 | 333000 | 999333 | -45 |
2 | 2023-08-23 20:00:00 | ADSY | 45 | 7777777 | 333000 | 999334 | 45 |
3 | 2023-08-23 20:00:00 | VIA | -45 | 7777777 | 333000 | 333000 | 0 |
4 | 2023-08-23 21:00:00 | VIR | 45 | 7777777 | 333111 | 333111 | 45 |
5 | 2023-08-23 21:00:00 | ADSY | -45 | 7777777 | 333111 | 999444 | 0 |
6 | 2023-08-23 21:00:00 | ADFY | 45 | 4444444 | 333111 | 999445 | 0 |
7 | 2023-08-30 05:00:00 | VXA | 45 | 7777777 | 333000 | 333000 | 45 |
8 | 2023-08-30 05:00:00 | VXR | -45 | 7777777 | 333111 | 333111 | 0 |
- Rows 1–2 — The transfer from the CC funding account to the CC spending account.
- Row 3 — The approved authorization amount. A 45.00 hold is placed on the CC spending account, so the available balance is 0.00.
- Row 4 — The reversal an hour later. Galileo reverses out the 45.00 hold, so the available balance is 45.00. For this transaction, the
prior_id
(reversal ID) would be333000
. - Rows 5–6 — The 45.00 is immediately transferred back to the CC funding account. Notice that the transaction codes are
SY
andFY
, because the transfers were triggered by a transaction from the authorization stream. - Rows 7–8 — The expiry of the authorization as well as the reversal seven days later.
For instructions on simulating this type of transaction see Authorization Reversal Simulation.
Reversal with settlement
The cardholder makes a $45 purchase on 12 Aug 2023 at 8:00 pm, and it is reversed an hour later. The network sends the reversal in the settlement file. The network is Visa. An authorization reversal followed by a settlement is not a common event.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-08-23 20:00:00 | ADFY | -45 | 4444444 | 333000 | 999333 | -45 |
2 | 2023-08-23 20:00:00 | ADSY | 45 | 7777777 | 333000 | 999334 | 45 |
3 | 2023-08-23 20:00:00 | VIA | -45 | 7777777 | 333000 | 333000 | 0 |
4 | 2023-08-23 21:00:00 | VIR | 45 | 7777777 | 333111 | 333111 | 45 |
5 | 2023-08-23 21:00:00 | ADSZ | -45 | 7777777 | 333111 | 999444 | 0 |
6 | 2023-08-23 21:00:00 | ADFZ | 45 | 4444444 | 333111 | 999445 | 0 |
7 | 2023-08-26 05:00:00 | VSA | 45 | 7777777 | 333000 | 333000 | 45 |
8 | 2023-08-26 05:00:00 | VXR | -45 | 7777777 | 333111 | 333111 | 0 |
- Rows 1–2 — The transfer from the CC funding account to the CC spending account.
- Row 3 — The approved authorization amount. A 45.00 hold is placed on the CC spending account, so the available balance is 0.00.
- Row 4 — The reversal an hour later. Galileo reverses out the 45.00 hold, so the available balance is 45.00. For this transaction, the
prior_id
(reversal ID) would be333000
. - Rows 5–6 — The 45.00 is immediately transferred back to the CC funding account.
- Row 7 — The settlement from the daily batch file, which arrives before the authorization would have expired. The settlement triggers the expiration of the reversal, in Row 8.
Merchant credit (Maestro)
The cardholder makes a $100 purchase on 3 Nov 2023 at 11:00 am. A week later, the cardholder returns the item for a full refund. The transaction settled before the item was returned. The network is Mastercard Maestro (debit). A Visa merchant credit (credit or debit network) follows the same process.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-11-03 11:00:00 | ADFY | -100 | 4444444 | 555222 | 222333 | -100 |
2 | 2023-11-03 11:00:00 | ADSY | 100 | 7777777 | 555222 | 222334 | 100 |
3 | 2023-11-03 11:00:00 | DBA | -100 | 7777777 | 555222 | 555222 | 0 |
4 | 2023-11-05 06:30:00 | BDA | 100 | 7777777 | None | 555222 | 100 |
5 | 2023-11-05 06:30:00 | SDA | -100 | 7777777 | 555222 | 555222 | 0 |
6 | 2023-11-10 14:00:00 | DBZ | 100 | 7777777 | 555333 | 555333 | 0 |
7 | 2023-11-12 06:00:00 | DBZ | 100 | 7777777 | 555333 | 555333 | 100 |
8 | 2023-11-12 06:00:00 | BDZ | -100 | 7777777 | None | 555333 | 0 |
9 | 2023-11-12 06:00:00 | SDZ | 100 | 7777777 | 555333 | 555333 | 100 |
10 | 2023-11-12 06:00:00 | ADSZ | -100 | 7777777 | 555333 | 222444 | 0 |
11 | 2023-11-12 06:00:00 | ADFZ | 100 | 4444444 | 555333 | 222445 | 0 |
- Rows 1–2 — The transfer from the CC funding account to the CC spending account.
- Row 3 — The approved authorization amount. A 100.00 hold is placed on the account, so the available balance is 0.00.
- Rows 4–5 — The transaction is backed out and settled.
- Row 6 — The advice for the merchant credit. However, the merchant credit is not posted to the account at this time.
- Rows 7–9 — The arrival of the merchant credit in the batch settlement file. Galileo creates a new authorization and backout entry before posting the credit.
- Rows 10–11 — The 100.00 is moved immediately back into the CC funding account.
Merchant credit (Mastercard credit)
This is exactly the same scenario as above only using Mastercard Banknet (credit). Galileo processes Mastercard Banknet merchant credits as adjustments. The cardholder makes a $100 purchase on 3 Nov 2023 at 11:00 am. A week later, the cardholder returns the item for a full refund.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-11-03 11:00:00 | ADFY | -100 | 4444444 | 555444 | 222333 | -100 |
2 | 2023-11-03 11:00:00 | ADSY | 100 | 7777777 | 555444 | 222334 | 100 |
3 | 2023-11-03 11:00:00 | AUA | -100 | 7777777 | 555444 | 555444 | 0 |
4 | 2023-11-05 06:30:00 | BO5 | 100 | 7777777 | None | 555444 | 100 |
5 | 2023-11-05 06:30:00 | SE5 | -100 | 7777777 | 555444 | 555444 | 0 |
6 | 2023-11-10 14:00:00 | ADC | 100 | 7777777 | None | 555666 | 100 |
7 | 2023-11-10 14:00:00 | ADSZ | -100 | 7777777 | 555666 | 222444 | 0 |
8 | 2023-11-10 14:00:00 | ADFZ | 100 | 4444444 | 555666 | 222445 | 0 |
- Rows 1–2 — The transfer from the CC funding account to the CC spending account.
- Row 3 — The approved authorization amount. A 100.00 hold is placed on the CC spending account, so the available balance is 0.00.
- Rows 4–5 — The transaction is backed out and settled.
- Row 6 — The merchant credit, which arrived at Galileo in the batch settlement file that Mastercard sent Galileo. Galileo processes the merchant credit as an adjustment.
- Rows 7–8 — The credit is moved out of the CC spending account back to the CC funding account.
Gas pump
The cardholder dispenses $50 worth of gas at a gas pump on 3 Jul 2023 at 10:00 am. There is a $75 upcharge for gas purchases. The network is Mastercard Maestro.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-07-03 10:00:00 | ADFY | -75 | 4444444 | 888555 | 222111 | -75 |
2 | 2023-07-03 10:00:00 | ADSY | 75 | 7777777 | 888555 | 222112 | 75 |
3 | 2023-07-03 10:00:00 | DBL | -75 | 7777777 | 888555 | 888555 | 0 |
4 | 2023-07-03 10:03:00 | PBPB | 75 | 7777777 | None | 888555 | 75 |
5 | 2023-07-03 10:03:00 | SDC | -50 | 7777777 | 888777 | 888777 | 25 |
6 | 2023-07-03 10:03:00 | ADSY | -25 | 7777777 | 888777 | 222222 | 0 |
7 | 2023-07-03 10:03:00 | ADFY | 25 | 4444444 | 888777 | 222223 | -50 |
8 | 2023-07-06 06:00:00 | BDA | 50 | 7777777 | None | 888777 | 50 |
9 | 2023-07-06 06:00:00 | SDA | -50 | 7777777 | 888777 | 888777 | 0 |
- Rows 1–2 — The amount of the preauthorization is moved from the CC funding account into the CC spending account.
- Row 3 — The approved authorization amount. A 75.00 hold is placed on the CC spending account, so the available balance is again 0.00.
- Rows 4–5 — The preauthorization hold is backed out and replaced by the –50.00 completion. Galileo replaces the 75.00 hold with a 50.00 hold, leaving 25.00 in the CC spending account.
- Rows 6–7 — The 25.00 is moved immediately from the CC spending account back into the CC funding account. The
trans_code
s are ADSY/ADFY because completions arrive at Galileo through the authorization stream. - Rows 8–9 — The 50.00 completion hold is backed out and settled.
For instructions on simulating this type of transaction see Five-Step Sequence Simulation.
Incremental authorization
A cardholder calls a ride-share service through its app, and the cost of the proposed destination is $25. The app authorizes the transaction at 9:00 am. After arriving at the first destination 20 minutes later, the cardholder requests a second destination for $15, and then after arriving at the second destination 30 minutes later, requests a third, for $10.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-07-07 09:00:00 | ADFY | -25 | 4444444 | 555111 | 444000 | -25 |
2 | 2023-07-07 09:00:00 | ADSY | 25 | 7777777 | 555111 | 444001 | 25 |
3 | 2023-07-07 09:00:00 | VIA | -25 | 7777777 | 555111 | 555111 | 0 |
4 | 2023-07-07 09:20:00 | PVPV | 25 | 7777777 | None | 555111 | 25 |
5 | 2023-07-07 09:20:00 | ADFY | -15 | 4444444 | 555222 | 444010 | -40 |
6 | 2023-07-07 09:20:00 | ADSY | 15 | 7777777 | 555222 | 444011 | 40 |
7 | 2023-07-07 09:20:00 | VIA | -40 | 7777777 | 555222 | 555222 | 0 |
8 | 2023-07-07 09:50:00 | PVPV | 40 | 7777777 | None | 555222 | 40 |
9 | 2023-07-07 09:50:00 | ADFY | -10 | 4444444 | 555333 | 444020 | -50 |
10 | 2023-07-07 09:50:00 | ADSY | 10 | 7777777 | 555333 | 444021 | 50 |
11 | 2023-07-07 09:50:00 | VIA | -50 | 7777777 | 555333 | 555333 | 0 |
12 | 2023-07-09 05:00:00 | BVA | 50 | 7777777 | None | 555333 | 50 |
13 | 2023-07-09 05:00:00 | VSA | -50 | 7777777 | 555333 | 555333 | 0 |
- Rows 1–2 — The amount of the authorization is moved from the CC funding account into the CC spending account.
- Row 3 — The approved authorization amount. A 25.00 hold is placed on the CC spending account, so the available balance is again 0.00.
- Row 4 — The 25.00 is backed out because Galileo received an incremental authorization request.
- Rows 5–6 — The additional 15.00 is moved from the CC funding to the CC spending account.
- Row 7 — The –40.00 incremental authorization request. Galileo places a 40.00 hold on the CC spending account, so the available balance is again 0.00.
- Row 8 — The 40.00 hold is backed out because Galileo received another incremental authorization request.
- Rows 9–10 — The additional 10.00 is moved from the CC funding to the CC spending account.
- Row 11 — The –50.00 incremental authorization request. Galileo places a 50.00 hold on the CC spending account, so the available balance is again 0.00.
- Rows 12–13 — The 50.00 hold is backed out and settled. Notice that the
auth_id
corresponds to the last authorization in the series.
Partial reversal on authorization
A cardholder goes to an agency to rent a car. The agency obtains a $500 preauthorization. The next day, the cardholder returns the car, and the bill comes to $60. The network is Mastercard Banknet (credit).
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-11-22 10:00:00 | ADFY | -500 | 4444444 | 444110 | 333222 | -500 |
2 | 2023-11-22 10:00:00 | ADSY | 500 | 7777777 | 444110 | 333223 | 500 |
3 | 2023-11-22 10:00:00 | AUL | -500 | 7777777 | 444110 | 444110 | 0 |
4 | 2023-11-23 11:00:00 | AUR | 440 | 7777777 | 444111 | 444111 | 440 |
5 | 2023-11-23 11:00:00 | ADSZ | -440 | 7777777 | 444111 | 333444 | 0 |
6 | 2023-11-23 11:00:00 | ADFZ | 440 | 4444444 | 444111 | 333445 | -60 |
7 | 2023-11-25 06:00:00 | EXR | -440 | 7777777 | None | 444111 | -440 |
8 | 2023-11-25 06:00:00 | BO5 | 500 | 7777777 | None | 444110 | 60 |
9 | 2023-11-25 06:00:00 | SE5 | -60 | 7777777 | 444110 | 444110 | 0 |
- Rows 1–2 — The amount of the authorization is moved from the CC funding account into the CC spending account.
- Row 3 — The approved preauthorization amount. A 500.00 hold is placed on the CC spending account, so the available balance is again 0.00.
- Row 4 — The preauthorization reversal for 440.00. The available balance is 440.00.
- Rows 5–6 — The reversal amount is moved back from the CC spending account to the CC funding account.
- Row 7 — The expiry of the 440.00 reversal, which is triggered by the arrival of the batch settlement file.
- Rows 8–9 — Galileo backs out the original 500.00 hold and posts –60.00 to the account.
Incremental clearing
A cardholder purchases three items from three different third-party vendors on the same online store. The items are for $150, $75, and $175. The online merchant obtains preauthorization for $400, and then each item is cleared separately when the vendors ship them.
post_ts | trans_code | amt | pmt_ref_no | auth_id | source_id | calculated_balance | |
---|---|---|---|---|---|---|---|
1 | 2023-10-01 14:00:00 | ADFY | -400 | 4444444 | 111444 | 888333 | -400 |
2 | 2023-10-01 14:00:00 | ADSY | 400 | 7777777 | 111444 | 888334 | 400 |
3 | 2023-10-01 14:00:00 | AUL | -400 | 7777777 | 111444 | 111444 | 0 |
4 | 2023-10-03 05:00:00 | BO5 | 150 | 7777777 | None | 111444 | 150 |
5 | 2023-10-03 05:00:00 | SE5 | -150 | 7777777 | 111444 | 111444 | 0 |
6 | 2023-10-05 06:00:00 | BO5 | 75 | 7777777 | None | 111444 | 75 |
7 | 2023-10-05 06:00:00 | SE5 | -75 | 7777777 | 111444 | 111444 | 0 |
8 | 2023-10-07 05:30:00 | BO5 | 175 | 7777777 | None | 111444 | 175 |
9 | 2023-10-07 05:30:00 | SE5 | -175 | 7777777 | 111444 | 111444 | 0 |
- Rows 1–2 — The amount of the authorization is moved from the CC funding account into the CC spending account.
- Row 3 — The approved preauthorization amount. A 400.00 hold is placed on the CC spending account, so the available balance is again 0.00.
- Rows 4–5 — The first settlement. Galileo backs out 150.00 of the hold and posts –150.00 to the account. The remaining hold is for 250.00.
- Rows 6–7 — The second settlement. Galileo backs out 75.00 of the hold and posts –75.00 to the account. The remaining hold is for 175.00.
- Rows 8–9 — The last settlement. Galileo backs out the remaining hold and posts –175.00 to the account.