Real-Time Funding Transaction Examples

This page contains examples of different types of real-time funding (RTF) transactions. For an explanation of real-time funding see About Real-Time Funding. 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 RTF funding and RTF spending accounts. For all examples the following is true:

  • 3333333 — PRN of the RTF funding account
  • 7777777 — PRN of the RTF spending account
  • The source_id for all adjustments refers to the adj_id in the adjustments table.
  • The RTF funding account contains 1000.00 as a beginning balance.
  • The RTF spending account contains 0.00 as a beginning balance.

Examples

Conventional purchase

A Mastercard cardholder makes a $35 purchase on 13 Jul 2023 at 9:00 am.

 post_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-07-13 09:00:00ADFY-353333333444555333666965
22023-07-13 09:00:00ADSY35777777744455533366735
32023-07-13 09:00:00AUA-3577777774445554445550
42023-07-15 07:31:22BO5357777777None44455535
52023-07-15 07:31:22SE5-3577777774445554445550
  • Row 1 — The transfer of funds out of the RTF funding account. The source_id refers to the entry in the adjustments table (adj_id).
  • Row 2 — The transfer of funds into the RTF spending account.
  • Row 3 — The approved authorization amount. A 35.00 hold is placed on the RTF spending account, so the available balance is 0.00. Between the time that the 35.00 is moved into the RTF 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 RTF spending account.

For instructions on simulating this type of transaction see Perform transactions in Testing Real-Time Funding in CV.

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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-08-23 20:00:00ADFY-453333333333000999333955
22023-08-23 20:00:00ADSY45777777733300099933445
32023-08-23 20:00:00VIA-4577777773330003330000
42023-08-23 21:00:00VIR45777777733311133311145
52023-08-23 21:00:00ADSY-4577777773331119994440
62023-08-23 21:00:00ADFY4533333333331119994451000
72023-08-30 05:00:00VXA45777777733300033300045
82023-08-30 05:00:00VXR-4577777773331113331110
  • Rows 1–2 — The transfer from the RTF funding account to the RTF spending account.
  • Row 3 — The approved authorization amount. A 45.00 hold is placed on the RTF 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 be 333000.
  • Rows 5–6 — The 45.00 is immediately transferred back to the RTF funding account.Notice that the transaction codes are SY and FY, 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-08-23 20:00:00ADFY-453333333333000999333955
22023-08-23 20:00:00ADSY45777777733300099933445
32023-08-23 20:00:00VIA-4577777773330003330000
42023-08-23 21:00:00VIR45777777733311133311145
52023-08-23 21:00:00ADSZ-4577777773331119994440
62023-08-23 21:00:00ADFZ4533333333331119994451000
72023-08-26 05:00:00VSA45777777733300033300045
92023-08-26 05:00:00VXR-4577777773331113331110
  • Rows 1–2 — The transfer from the RTF funding account to the RTF spending account.
  • Row 3 — The approved authorization amount. A 45.00 hold is placed on the RTF 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 be 333000.
  • Rows 5–6 — The 45.00 is immediately transferred back to the RTF 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-11-03 11:00:00ADFY-1003333333555222222333900
22023-11-03 11:00:00ADSY1007777777555222222334100
32023-11-03 11:00:00DBA-10077777775552225552220
42023-11-05 06:30:00BDA1007777777None555222100
52023-11-05 06:30:00SDA-10077777775552225552220
62023-11-10 14:00:00DBZ10077777775553335553330
72023-11-12 06:00:00DBZ1007777777555333555333100
82023-11-12 06:00:00BDZ-1007777777None5553330
92023-11-12 06:00:00SDZ1007777777555333555333100
102023-11-12 06:00:00ADSZ-10077777775553332224440
112023-11-12 06:00:00ADFZ10033333335553332224451000
  • Rows 1–2 — The transfer from the RTF funding account to the RTF 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 RTF 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-11-03 11:00:00ADFY-1003333333555444222333900
22023-11-03 11:00:00ADSY1007777777555444222334100
32023-11-03 11:00:00AUA-10077777775554445554440
42023-11-05 06:30:00BO51007777777None555444100
52023-11-05 06:30:00SE5-10077777775554445554440
62023-11-10 14:00:00ADC1007777777None555666100
72023-11-10 14:00:00ADSZ-10077777775556662224440
82023-11-10 14:00:00ADFZ10033333335556662224451000
  • Rows 1–2 — The transfer from the RTF funding account to the RTF spending account.
  • Row 3 — The approved authorization amount. A 100.00 hold is placed on the RTF 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 RTF spending account back to the RTF 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-07-03 10:00:00ADFY-753333333888555222111925
22023-07-03 10:00:00ADSY75777777788855522211275
32023-07-03 10:00:00DBL-7577777778885558885550
42023-07-03 10:03:00PBPB757777777None88855575
52023-07-03 10:03:00SDC-50777777788877788877725
62023-07-03 10:03:00ADSY-2577777778887772222220
72023-07-03 10:03:00ADFY253333333888777222223950
82023-07-06 06:00:00BDA507777777None88877750
92023-07-06 06:00:00SDA-5077777778887778887770
  • Rows 1–2 — The amount of the preauthorization is moved from the RFT funding account into the RTF spending account.
  • Row 3 — The approved authorization amount. A 75.00 hold is placed on the RTF 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 RTF spending account.
  • Rows 6–7 — The 25.00 is moved immediately from the RTF spending account back into the RTF funding account. The trans_codes 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-07-07 09:00:00ADFY-253333333555111444000975
22023-07-07 09:00:00ADSY25777777755511144400125
32023-07-07 09:00:00VIA-2577777775551115551110
42023-07-07 09:20:00PVPV257777777None55511125
52023-07-07 09:20:00ADFY-153333333555222444010960
62023-07-07 09:20:00ADSY15777777755522244401140
72023-07-07 09:20:00VIA-4077777775552225552220
82023-07-07 09:50:00PVPV407777777None55522240
92023-07-07 09:50:00ADFY-103333333555333444020950
102023-07-07 09:50:00ADSY10777777755533344402150
112023-07-07 09:50:00VIA-5077777775553335553330
122023-07-09 05:00:00BVA507777777None55533350
132023-07-09 05:00:00VSA-5077777775553335553330
  • Rows 1–2 — The amount of the authorization is moved from the RFT funding account into the RTF spending account.
  • Row 3 — The approved authorization amount. A 25.00 hold is placed on the RTF 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 RTF funding to the RTF spending account.
  • Row 7 — The –40.00 incremental authorization request. Galileo places a 40.00 hold on the RTF 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 RTF funding to the RTF spending account.
  • Row 11 — The –50.00 incremental authorization request. Galileo places a 50.00 hold on the RTF 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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-11-22 10:00:00ADFY-5003333333777444333222500
22023-11-22 10:00:00ADSY5007777777777444333223500
32023-11-22 10:00:00AUL-50077777777774447774440
42023-11-23 11:00:00AUR4407777777777555777555440
52023-11-23 11:00:00ADSZ-44077777777775553334440
62023-11-23 11:00:00ADFZ4403333333777555333445940
72023-11-25 06:00:00EXR-4407777777None777555-440
82023-11-25 06:00:00BO55007777777None77744460
92023-11-25 06:00:00SE5-6077777777774447774440
  • Rows 1–2 — The amount of the authorization is moved from the RFT funding account into the RTF spending account.
  • Row 3 — The approved preauthorization amount. A 500.00 hold is placed on the RTF 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 RTF spending account to the RTF 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.

Force post

A cardholder makes a $15 purchase at a store. Technical problems prevent the merchant from getting an authorization at sale time, so the next day the merchant sends a force posting in the settlement batch file.

 post_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-09-21 07:30:00ADFZ-153333333999111111444985
22023-09-21 07:30:00ADSZ15777777799911111144515
32023-09-21 07:30:00DBM-1577777779991119991110
42023-09-21 07:30:00BDM157777777None99911115
52023-09-21 07:30:00SDM-1577777779991119991110
  • Rows 3–5 — When Galileo receives a settlement for a transaction that has no corresponding authorization, Galileo creates an authorization, backs it out, and settles it at the same time.
  • Rows 1–2 — The transaction amount is moved from the RTF funding account to the RTF spending account before the authorization is created.

For instructions on simulating this type of transaction see Force-Post Simulation.

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_tstrans_codeamtpmt_ref_noauth_idsource_idcalculated_balance
12023-10-01 14:00:00ADFY-4003333333111444888333600
22023-10-01 14:00:00ADSY4007777777111444888334400
32023-10-01 14:00:00AUL-40077777771114441114440
42023-10-03 05:00:00BO51507777777None111444150
52023-10-03 05:00:00SE5-15077777771114441114440
62023-10-05 06:00:00BO5757777777None11144475
72023-10-05 06:00:00SE5-7577777771114441114440
82023-10-07 05:30:00BO51757777777None111444175
92023-10-07 05:30:00SE5-17577777771114441114440
  • Rows 1–2 — The amount of the authorization is moved from the RFT funding account into the RTF spending account.
  • Row 3 — The approved preauthorization amount. A 400.00 hold is placed on the RTF 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.


©Galileo Financial Technologies, LLC 2025

All documentation, including but not limited to text, graphics, images, and any other content, are the exclusive property of Galileo Financial Technologies, LLC and are protected by copyright laws. These materials may not be reproduced, distributed, transmitted, displayed, or otherwise used without the prior written permission of Galileo Financial Technologies, LLC. Any unauthorized use or reproduction of these materials are expressly prohibited.