Maybe this will help guide your setup.
This is a classic deferred revenue + loyalty/promotion scenario, and you're on the right track. Business Central doesn’t natively support FIFO-style tracking for prepaid balances like inventory costing, but you can achieve your goal using a combination of:
Recommended Approach:
1. Create a customer ledger or prepaid card table to track:
Load amount
Bonus/promo amount
Card number
Date loaded (for FIFO logic)
2. Post journal entries:
Load amount to Deferred Revenue (Liability)
Bonus amount to Contra Deferred Revenue (or Promo Expense)
3. Track usage per card with custom logic or extension:
On usage, reduce the balance FIFO-style based on load date
Reverse deferred entries proportionally: actual + promo portions
Post revenue and any promo/write-off to appropriate GL accounts
4. Custom AL code or Power Automate may be needed to automate FIFO application and reduce reliance on Excel.
Unfortunately, there’s no built-in FIFO method for prepaid balances, but it can be developed using custom journals, dimensions, or extension logic similar to how inventory valuation layers work.
Mark below checkbox to make this answer Verified if it helps you. Let me know if you want a code-level approach to build the FIFO logic.
