Reconciling Miller's Statement
Notes Before Beginning
Reconciling the monthly Miller's statement is a little different than running remittance for our other lab partners. Here are the things you need to know:
- Miller's updated their pricing on their website, so we in turn updated pricing on our end; however, pricing was not updated for their direct orders. This means we are billed based on their old pricing, requiring us to subtract $5-10 from every order before calculating remittance.
- You can find Miller's old pricing here.
- Discount is 15% for total order
- Send us invoice via snail mail
- Deduct $5-10 from order total (albums only, see this doc for previous prices), as they have not updated their pricing to match what’s on their website (as of July 2021)
- Email total due for the month (listed at end of invoice) to Jonathan and Lisa ([email protected]) for approval.
- See Disney SOP for how to calculate and bill Disney.
Getting Started
Open the Miller's statement and go to CCpro to begin searching for customers. For this example, I'll use Teri Bocko's order
After finding the customer's account in CCpro, you can cross-reference the order number from the invoice to make sure it matches the one in ccpro. Unlike Fundy or Miller's standard order numbers, these orders typically start with 602.
After ensuring you have the correct order open, begin reconciling the order total. Since Miller's hasn't updated pricing for their direct albums, you'll need to open the old pricing spreadsheet and find out how much to subtract from the order.
For example:
Teri's order breakdown shows she paid $56 base for a 10x10 Signature book; however, the spreadsheet shows that it was previously $51. This means that in order to reconcile the order total, you will need to subtract $5 from the total.
Example continued:
Teri's order total in CCpro shows as $91. To reconcile, subtract $5 from the $91 total, then multiple by 85%. Here's the breakdown:
$96 - $5 = $91
$91 x 0.85 = $77.35 (amount shown on Miller's statement)
If the amounts match after your calculations, then simply highlight the line item on the invoice to notate that it is approved.
Having trouble reconciling?
Check the following:
- Make sure it's not a sample order (check order details box across from spread thumbnails). If it is a sample order, you'll need to subtract an additional 25% (after subtracting the $5-10 and before multiplying by 85%)
- Check that the customer hasn't been double charged for imprinting, extra spreads, or covers. Going back and forth in the Fundy direct cart can result in double charges. In this case, subtract the difference before calculating the remittance amount.
- Check to see if it's a magazine order. Magazines have a higher discount, so the numbers never reconcile. Simply move on to another order.