- June 15, 2018 at 5:14 pm #204884
Hi. I am working on invoicing for a client who owns a business. He has printouts (from the bank?) of approved credit and debit card transactions listing the approval date, the approval code, the numeric portion of the customer’s address, the type of card (MasterCard or Visa), and the last four digits of the card. The customer’s name is not on the printouts.
How do I record these payments without the customer name? My client said that I can match the credit card payments to the correct invoices/customer by “dates and amounts.” I cannot figure out how to do that without the customer name.
Thank you so much.
MichelleJune 15, 2018 at 5:26 pm #204954
Hey Michelle, there are several ways to record credit/debit card payments. The easiest way to do this is to just record the sale and payments (without entering customer info). To do this, you can create a sales receipt in QuickBooks and instead of entering the customer’s name, you can just enter something like “Sales for June 15, 20xx”. Use the date that the funds were deposited in the bank account so that you can easily reconcile the accounts with your bank statements.
If you prefer to record these payments by customer, you will need to ask your credit card merchant how you can obtain reports that include the customer’s name so that you can try and match them up with the deposits made to your bank account. Once you have the customer’s name, you can create a sales receipt and just be sure to select the customer’s name (instead of putting a date) like we mentioned above.
Below, I have included three video tutorials that are great resources for managing these type of transactions:
Feel free to reach out with any additional questions you may have.
Crystalynn Shelton, CPA