Cash Revenues
Cash Revenues genearlly include all cash deposits received in the normal course of business operations such as customer invoice payments, interest income, and customer deposits. Cash receipts related to transfers and equity financing are excluded from Cash Revenues.
Cash Revenues Calculation
The calculation of cash revenues in Rillet begins with all journal entry lines where the following two criteria are met:
The Debit Line of the JE includes an account where the Subtype = Bank or Credit Card
The Credit Line of the JE includes an account where the Subtype is Accounts Receivable, Other Current Asset, Other Assets, Revenue, Non Operating Income or Customer Deposits
Once the relevant journal entries have been determined the amount of the cash revenue is determined as follows:
If the Bank JE Line Amount < Revenue Amount, then the Cash Revenue Impact = Bank Transaction Amount
If the Revenue Amount ≤ Bank Transaction, then the Cash Revenue Impact = Revenue
This distinction is particularly important in the case where there is a Match & Adjust used for a customer payment or when there is an realized gain/loss for FX impact.
Cash Revenues Examples
Example 1: Customer Invoice Payment
Lets assume you send an invoice to your customer on Jan 01 2024 for $5,000. You receive the payment from your customer into your bank account on Mar 31 2024. On March 31 2024, the following JE is recorded:
DR: Cash $5,000
CR: Accounts Receivable $5,000
In this case, the Cash Revenues impact on March 31 2024, would be $5,000.
Example 2: Customer Invoice Payment with Bank Fees
Lets assume you send an invoice to your customer on Jan 01 2024 for $5,000. You receive the payment from your customer into your bank account on Mar 31 2024, but the bank deducted a $20 wire fee. On March 31 2024, the following JE is recorded:
DR: Cash $4,980
DR: Bank Fees $20
CR: Accounts Receivable $5,000
In this case, the Cash Revenues impact on March 31 2024, would be $4,980 because the bank (cash) line is less than the impact to Accounts Receivable.
Example 3: Customer Invoice Payment with Realized Gain
Lets assume you send an invoice to your customer on Jan 01 2024 for $4,800 euros, which is equal to $5000 USD on the invoice date. You receive the payment from your customer into your bank account on Mar 31 2024. The amount you receive is $5,100 due to exchange rate gains. On March 31 2024, the following JE is recorded:
DR: Cash $5,100
DR: Realized Gain/Loss $100
CR: Accounts Receivable $5,000
In this case, the Cash Revenues impact on March 31 2024, would be $5,000 because the bank (cash) line is greater than the impact to Accounts Receivable.
Example 4: Customer Deposit
Lets assume you your customer sends you an advance deposit on their usage credits on March 31 2024 for $5,000. On March 31 2024, the following JE is recorded:
DR: Cash $5,000
CR: Customer Deposits $5,000
In this case, the Cash Revenues impact on March 31 2024, would be $5,000.
Last updated