This was followed by an experience of sharing different first-and-renewal methods of calculating freight costs, and this time, the reconciliation of the delivery shipment volume with the courier company, and how the monthly shipment batch reconciliation was fast and accurate. The main application is for the bulk handling of freight charges to be checked in the company's mail with the express delivery company at its monthly closing。
Methodology/step
Each month, the mail company has its own bill of freight statistics, and the fast-ding delivery will issue a statement of account, which we have collated in two original data sheets from different sources and placed in the excel form in two separate forms. Table 1, like the detailed statements sent by express, shows the billings of the sending companies in table 2, naming tables 1 and 2, respectively。
First, using the function formula: vlookup applies this function to each of the two tables, each of which corresponds to another table, so that a single number matches the shipping details of the mail and courier companies. It should be noted here that (1) the vlookup formula requires a single number before the freight is calculated and, if this is not the case, adjustments are made。
(2) there is a possibility that the "triangular" number and freight charges sent by the express delivery company are preceded by a "triangular" format, whereby the file cells are treated "disaggregated" and the previous "triangular" is removed for matching checks using the vlookup function. This is done according to the “data” - “disaggregated” - “separated symbols” step in the excel table. If the data are converted to scientific algorithms, then you can process the cell format。
For vlookup, the consistent freight charges were correct and no further reasons were sought. On the other hand, in the case of inconsistent individual reconciliations, see what causes the discrepancies in freight costs, the more common cases being inconsistent weights and wrong destination calculations。
For statements sent by couriers, this ensures that each single number is charged only once and does not result in double billing by the same single number. Sets the formula in the first row of a single number, and then pulls the formula down as a whole。
1. If two checks have been performed, possibly the range of data for the month or months ahead, a single search of the single number at the end of the previous month or at the beginning of the month is required. For those units that were not found, it is possible that the courier company miscalculated the numbers. Or a separate company number, which requires further scrutiny。
The reconciliation will be completed by reconciling the above discrepancies with the express delivery company, by issuing one additional adjustment to the courier company, and by adjusting the freight charges for the discrepancies in its estimates。
If you need to address specific problems (in particular in the fields of law, medicine, etc.) you are advised to consult professionals in the relevant fields in detail。
The author states that the present section of the experience was originally written by me on the basis of real experience and was rejected without permission。
