Trip costs: advances, receipts and closing review
An advance and its receipts are not two separate costs. Preserve payment sources, outstanding items and returns to explain the trip result.
Test ten trip-closing decisions
Reconcile advance, receipts, card, returns and reimbursement with synthetic amounts. Fill observed results after testing.
Separate funds issued, approved expenses and trip result
Closing trip costs requires identifying service, vehicle, driver, agreed revenue, expenses and payment sources. An advance provides operating funds; it must not become another expense alongside the receipts it finances. Separate approved costs, amounts awaiting review and money still to be returned or reimbursed.
Microsoft documents Business Central recording employee-paid expenses and subsequent reimbursement, with payments reconciled against related entries. These are that product's features. Verify that your system links expense and settlement: reimbursing a driver must not create the same cost again.
| View | Compares | Error prevented |
|---|---|---|
| Driver funds | Advance, reported spending and returned balance | Counting the advance as another cost |
| Trip cost | Approved expenses by reference and source | Duplicating receipts or reimbursements |
| Operating result | Agreed revenue minus included costs | Presenting an incomplete result as final profit |
Example: three thousand advanced, three thousand nine hundred in costs
| Record | Amount MXN | Test treatment |
|---|---|---|
| Driver advance | 3,000 | Funding source; not a new expense |
| Advance-funded fuel | 1,800 | Trip expense with reference |
| Advance-funded tolls | 650 | Trip expense with reference |
| Advance-funded meals | 250 | Expense to review and approve |
| Returned unused funds | 300 | Funds settlement; not freight revenue |
| Company-card fuel | 1,200 | Separate identified expense; do not duplicate advance |
Funds close with 3,000 issued equal to 2,700 spent plus 300 returned. If all expenses are approved, costs total 2,700 plus 1,200: 3,900. The operating result within the test scope is 8,000 minus 3,900, or 4,100. Agreed revenue does not prove customer payment, and the result excludes the expressly omitted costs.
At first the meals lack readable evidence. Approved costs are 3,650 with 250 awaiting review, even though the driver reports spending 2,700. A preliminary view may show 4,350 against approved costs, but must retain the 250 pending amount and avoid declaring a final close. When the authorized person accepts evidence, approved cost becomes 3,900 and result 4,100.
A repeated receipt is not another toll
The 650 toll document arrives twice. Identify the same receipt, trip and transaction: preserve one 650 expense. Two distinct tolls with equal amounts must not be discarded solely because the amounts match; require distinguishing references. Also prevent a receipt assigned to another trip from becoming VT-26 cost without an authorized correction.
In an independent variant, the driver pays 150 for parking personally and the expense is approved. Costs rise to 4,050 and the scoped result falls to 3,950. A 150 reimbursement remains due to the driver; payment confirmation settles that obligation without adding another 150 of cost. The advance still closes with 2,700 reported and 300 returned because parking used another source.
| Condition | Expected outcome | Owner |
|---|---|---|
| Unreadable or unauthorized expense | Awaiting review, separate from approved | Supervisor |
| 300 return not yet confirmed | Funds outstanding; no complete settlement | Cashier |
| 150 reimbursement requested but unpaid | Approved cost; outstanding payment visible | Payments |
| Agreed 8000 revenue uncollected | Operating result separate from collections | Administration |
| Other currency or wrong trip | Review assignment and conversion rule | Administration |
Evaluate closing with different documents and funding sources
- Record an advance and the expenses consuming it. Costs must not include the advance again.
- Keep an expense awaiting review, then approve it. Distinguish preliminary result from final closure with outstanding items.
- Import a duplicate receipt and two distinct equal-amount receipts. Check identity rather than the total alone.
- Approve a personally paid expense and confirm reimbursement later. Expense appears once, settlement separately.
- Attempt closing without returned surplus, with another trip's document or another currency. Require a decision and owner.
Prepare an anonymized trip with advances, receipts, card payments and returns. Define categories, approval authority, result scope and closure conditions. Accounting, tax and shared-cost classification belongs to your responsible team; the worksheet proposes operational tests with illustrative amounts, not financial advice.
For payment and deposit separation, review order payment reconciliation; for a broader dashboard, business visibility. A trucking software consultation can examine trip references, spending sources and closure requirements.
Frequently asked questions
In this test it is a funding source. The expenses it finances are identified and reviewed separately; adding the advance again duplicates cost. Your accounting team determines the applicable recording.
No. The example subtracts only included costs from agreed revenue. It excludes fixed costs, separately stated taxes and other accounting items, and does not establish collection.
Preserve reported amount, reason and review owner separately from approved cost. Business policy decides acceptable evidence and resolution.
If the expense is already approved and included, payment settles the obligation rather than create the same expense again. Test reference, source and the link between records.
Sources
- Record and reimburse employees' expensesMicrosoft Learn
Last updated: