Recording Factoring/Miscellaneous Costs
The TMS is meant to handle recording shipping costs, not transactions costs as part of the operations to collect/process payment. Below is a guide on how we expect users to record separate fees within accounting software separately.
Here's a scenario that explains how other Tai brokers handle this entry within Tai and their accounting system.
Scenario
The factoring company advances $9,000 (90% of $10,000).
When the shipper pays, the factoring company deducts 2% = $200.
The factor remits the reserve minus the fee: $1,000 – $200 = $800.
Scenario
- Shipper Invoice: $10,000
- Carrier bill: $7,500
- Factoring company terms:
- 90% advance
- 2% fee
- Balance paid upon shipper payment
- TMS records:
- Sell (AR): $10,000
- Buy (AP): $7,500
- Gross Margin (in TMS): $2,500
- Accounting entry:
- AR – Shipper: $10,000
- Revenue: $10,000
- Accounting entry:
- Carrier Expense (COGS): $7,500
- AP – Carrier: $7,500
The factoring company advances $9,000 (90% of $10,000).
- Accounting entry:
- Cash: $9,000
- Due from Factor (Reserve Receivable): $1,000
- AR – Shipper: $10,000 (offset since factor now owns it)
When the shipper pays, the factoring company deducts 2% = $200.
- Accounting entry:
- Factoring Expense: $200
- Due from Factor: –$200
The factor remits the reserve minus the fee: $1,000 – $200 = $800.
- Accounting entry:
- Cash: $800
- Due from Factor: –$800
- Cash received = $9,800
- Carrier paid = $7,500
- Net Profit = $2,300
- Gross Margin in TMS = $2,500 (shipment-level, before financing costs)
- Factoring Expense in accounting = $200 (appears separately as a financing cost)