“Excel Transactions” helps you to import the invoices effortlessly. Refer the below link to know more.
After the invoices, we run behind the payments. Again “Excel Transactions” is a rescue when you need to import hundreds of Payments.
You can refer below links for detailed steps to import payments.
In QuickBooks, once the payment made against an Invoice, the PAYMENT status of the invoice becomes “PAID”. Sometimes it becomes “Partially Paid” when the payment made is less than the invoice amount.
To balance out our books, you may want to make sure that the payment amount should be the same as Invoice Amount. How is it possible to validate each payment amount manually?
“Excel Transactions” has settings to prevent the payments when it does not have the same amount of an Invoice.
You can open up “Import Settings” from Settings Menu or you can click on “Settings” button.
Navigate to “Advanced” tab and enable “Notify mismatching amount in Received Payment and Bill Payment for the corresponding Invoice and Bill respectively”.
If the amounts are mismatched (Invoice Amount and Payment Amount), you will get an error message on the Import Result Screen.