Shipment identity
Connect documents to the same movement.
Shipment IDAWB / B/L No.Order No.Invoice No.Output blueprint
Keep extracted charges, allocation logic and exceptions separate
A cost workbook is easier to audit when source values are not overwritten by calculations.
Source charge
Preserve the original financial fact.
Charge TypeOriginal CurrencyOriginal AmountSource PageAllocation inputs
Make the chosen basis visible and editable.
FX RateAllocation BasisWeight / Qty / ValueAllocation ShareReview controls
Separate unresolved records before handoff.
Duplicate FlagUnmatched FlagReviewerReview StatusWhat makes this document hard
These are the real formatting and workflow issues teams usually run into.
01
One shipment's cost can be split across carrier invoices, customs records, commercial invoices and local charge notes.
02
Freight, fuel, handling, duty and insurance may use different currencies, units and allocation rules.
03
A total without its source file and page is difficult to audit, while duplicates and unmatched charges can be missed.
How FOVATA handles it
The goal is not just conversion. The goal is structured output your team can use immediately.
Extract and link charges using shipment, AWB, bill-of-lading, invoice or order references.
Keep charge type, original currency, original amount, FX rate and source location as separate fields.
Export shipment summaries, item allocations and an exception queue for finance or logistics review.
AI Smart Extraction
Best when the source layout is inconsistent and the target output needs to follow business logic.
Excel-ready output
The point is not to mirror the source page. It is to create an output file that saves follow-up work.
Fields teams usually extract
Shipment IDAWB / B/L No.Invoice No.Charge TypeOriginal CurrencyOriginal AmountFX RateAllocated AmountSKU / OrderSource FileSource PageReview Status
Teams that benefit most
Logistics cost teams
Supply-chain finance
Import operations
Inventory costing teams
Recommended workflow
A practical three-step path from source file to usable Excel output.
1
Upload the shipment's freight, invoice, customs and surcharge documents, then define the linking identifiers.
2
Extract charge lines, normalize charge categories and currencies, and choose an approved allocation basis.
3
Review unmatched, duplicate and unusual charges before exporting the cost workbook.
FAQ
Does this calculate the final accounting cost automatically?
It creates a reviewable extraction and allocation workpaper. Your finance team must confirm exchange rates, allocation policy and the final accounting treatment.
How should multiple currencies be handled?
Keep original currency, original amount, FX rate and converted amount in separate columns, then confirm the rate date and source.
What happens to a charge that cannot be linked?
It should stay in an exception queue instead of being forced onto a shipment or item.
Use this page as your first test scenario
Test one shipment packet with several charge documents and verify identifiers, charge categories and allocation rules before scaling.