The Payments Received report is where you can show all the money that has come in from your customers. Use this report as a reconciliation report with QuickBooks to make sure that the payments entered in iPoint have been pushed to QB.
The report shows information about payments, including:
- Txn Date – the date the transaction took place
- Payment Method – what type of payment was used, (e.g. cash, check, Visa)
- Amount – the dollar amount of the payment
- Available Balance – how much of the payment is still available to pay toward an invoice.
- If the payment has been applied to an invoice, the invoice numbers will be displayed in grey under the available balance. And if the payment is fully applied to an invoice, the available balance will be $0.00.
- Check # – the number of the check as entered on the payment
- Memo – the note that was added to the payment. Note: when a payment is made on an RFP invoice, iPoint places the name of the Sales Rep in the memo field.
Note: The Date, Amount, Check #, and Memo fields are editable here on the report. Just be aware that editing an amount does not automatically update the information in QuickBooks. You’ll have to resync the payment to capture these changes in your financials.
The Options button presents several summarize and filter settings, which can be used in combination with one another.
- Sort By – use this dropdown menu to sort payment methods based on one of these criteria:
- Customer – all payments made by each customer are grouped together with a total of all payments per customer displayed. If a customer has multiple jobs (like Vacation Home, Mother-In-Law Home) this report breaks down payments per Customer: Job.
- Parent Customer – all payments made by each customer are grouped together regardless of the existence of a sub-job or child. Totals per customer are displayed.
- Payment Method – groups all payments together based on the type of payment (e.g. cash, check, credit card). This is a great way to reconcile a credit card statement, for example. Totals per payment type are displayed as well.
- Payment Method/Customer – all payment types are grouped together, followed by a sub-grouping of customers. The customer subtotal is displayed as well as the total of each payment method.
- Payment From Date and Payment To Date – use these dates fields to select a date range of payments. This option helps when trying to reconcile a Point of Sale register for a specific day.
- Customer – if you only want payments for a particular customer, choose a customer name from the dropdown list. Click in the customer name field and type a letter or series of letters to display customers that start with that string. Type “MA” for example, to find Magoo, Mister.
- Class – should your company be using classes on payments, you can filter the list by a specific class of payment. Use this to find payments for one specific store location.
- Balance Due – will determine if the payments shown include a balance due.
- Show Only – only shows payments that have not been fully applied to invoices.
- Don’t Show – only fully applied payments will be included in the report.
- Show All – shows all payments, regardless of balance. This is the same list as if no balance due is chosen.
Print will cause the report to be sent to your printer.
Save creates a PDF and opens a save dialogue so you can determine where to save the report.
Email attaches a PDF of the report to an email using your default email program.
Close and Update applies any of the sort and filter options set above to the displayed report.