Customer Entry Lockbox Update Report sample

Check Summary sample

12/19/17 Fri 14:16 Co: 1000 Wholesale Distributor Inc.      arelu      Oper: sys    Page:2
                               Accounts Receivable Lock Box – Update Lock Box

Check Summary for Batch: 1

Check #    Bank  Routing #/Checking Account #        Amount     Misc
1          308080903       0032157843                100.00  u 

           Total  Batch Amount                       100.00 

(W) – Check Posting includes Write-Offs 
(C) – Check Posting includes Chargebacks 
(U) – Check Posting includes Unapplied Cash Created 
(S) – Check Posting includes Suspended Transactions 
Proof  Was Out of Balance 

Check Application by Customer

Check Application by Customer: 
                   
Customer #:     111  Apex Construction  
                  
Shipto    Bank  Routing/Checking Acct #   Check  #  Check  Amt   Invoice    Invoice  Terms Amount Variance 
Unapplied 
Applied                Amount   Code Applied  Amount   Cash
-------------------------------------------------------------------------------------------------------------                               
308080903       0032157843          1        100.00    Unapp  Cash   0.00            0.00   0.00    17.60
1-99   12.00          11.76   0.00     0.00
2-99   15.00          14.70   0.00     0.00
3-99   42.00          41.16   0.00     0.00

Total for Check #                           1        85.30                                67.62   0.00   17.68

Total for Customer                                   85.30                                67.62   0.00   17.68

Customer #       211  Rainbow Painters
Shipto    Bank  Routing/Checking Acct #   Check  #  Check  Amt   Invoice    Invoice  Terms Amount Variance 
Unapplied
Applied                Amount   Code Applied  Amount   Cash
-------------------------------------------------------------------------------------------------------------                 
308080903      0032157988          1         100.00      32-99     15.00          14.70    0.99    0.00

            Total  for Check #               1         14.70                             14.70    0.00    0.00 

            Total  for Customer                        14.70                             14.70    0.00    0.00

* - Indicates Split Check