DR Number/s – include all DR number covered by the payment.

Customer Name – use name registered in QB. If customer not in the choices in data validation, add it to database tab on the same sheet.

Type of payment – cash and check payments are the type of payments to be remitted in the remittance sheet.

Check Details – name of bank/branch, check number, and check date are needed for check payments for remittance.

DR amount – if multiple DR, input the sum of amount of all invoices covered by the payment. There are times that the DR amount of an invoice is not equal to the amount paid due to returns and revision made during the transaction, in this case check for the new DR amount in QB.

Amount Paid – always input the actual amount paid by the customer. If the amount in receipt do not tally on the amount of payment you counted, change the amount in receipt equal to the amount of received payment.

Discrepancy – if the number is positive, look for the amount you input in the columns for DR amount and Amount paid maybe there are errors, otherwise it is overpayment. If the number is negative, then it is underpayment.

PR/CR number – receipt number is usually located at the upper right side of the receipt.

Sources – it is where the payments came from.

• Pick-up 

• EcoSci Trucks

• External

• Retail Store

• Collectimizer

• Collector

EWT – there are payments less with EWT. Tick checkbox only if they provided form 2307.

Remarks – this is where you input reasons for the discrepancy or any other remarks.