RECONCILIATION STEP 1: Accounting 1 report: sales broken down by indiv. lots, comes from "Accounting 1" report from reportico, filters invoice's most recent (non-shipping) payment date Accounting 2 report: all invoices for the period based on invoice's most recent payment date for invoices with balance <= 0. Accounting 3 report: all payments from invoices where the most recent payment date is in the date range Objective: All invoice IDs on accounting 2 should be on accounting 1. All invoice IDs on accounting 3 should be on accounting 1. Invoice IDs should be the same across all actually. Need to explain if there are "FALSE" results on any line items. Explanation goes in "notes" column. STEP 2: Go through accounting 1, and correct BOLs. See columns R-U where we determine if COGS values are consistent per BOL. Some may have incorrect auction pallets OR COGS entered. If there are inconsistencies, find correct COGS or auction pallets in the lotting app for each BOL and enter correct value. Do the same for BOL shipping. For COGS for TRG check https://docs.google.com/spreadsheets/d/1WaCgtNHoih_kbRuYUOhLfOe8bRe1smKlb4P0cORO3m4/edit#gid=0. For others check https://docs.google.com/spreadsheets/d/1VorVkG_XPwmDX-HpCaRizwkCvzEQKAK4_kmv1tcXJHw/edit#gid=1842378877 STEP 3: Go through all BOLs one by one to make sure data is correct.
Comments