Icon

How to Add Receipts to Monthly Credit Card Bills in QuickBooks: Step-by-Step Guide

Learn the essential daily process for adding receipts or line items to the correct monthly credit card bill in QuickBooks. This guide covers grouping charges by employee, sorting by date, using Text Blaze snippets, and ensuring accurate account selection.

By Tim Moody

Getting Started

This is the most important guide in the credit card collection. The daily task is to add any credit card receipts as line items to the correct monthly bill. Before you begin, ensure Text Blaze is running. We will use a specific snippet to type our memo notations--consistency is important. Also, open the Common CC Expense Accounts (Cheat Sheet) from this collection if you're unsure which account to use for the receipts you are about to enter.

Okay, let's get started. From the QuickBooks home screen, click on the Vendor Center.

1
Click on "Vendors"
Step #1: Click on "Vendors"

Now, I'll find and click Tompkins to open the vendor profile.

2
Click here
Step #2: Click here

The first step is to find the correct master bill. If your receipt is from the first 10 days of the month, such as October 8th, it likely belongs on the prior month's bill. My receipts right now are from later in October, so I will open the October general expense bill.

3
Double-click on "Oct General Expense"
Step #3: Double-click on "Oct General Expense"

Now that the bill is open, I need to find the correct place for my new line. The rule is: group all charges by employee. Then, sort each employee's charges by date.

Example 1: Adding a New Charge to the Bottom

For the first example, I have a gasoline receipt here from John. I'm scanning the list and see that John has no charges on this bill yet. This makes it easy.

I can start his group at the bottom. Now, I click in the account column.

4
Click here
Step #4: Click here

This is a gasoline receipt, so I will select the "Maintenance and Repairs:gasoline" expense account.

5
Click on "gasoline"
Step #5: Click on "gasoline"

Then, I will press the Tab key on my keyboard to move the cursor to the amount field, then type the dollar amount from the receipt.

Next, I’ll tab over to the memo field. Here, I’ll activate my snippet. To do that, type "/cce". This stands for credit card entry.

6
Type cce
Step #6: Type cce

After activating the snippet, a form appears with a drop down menu to select the employee name.

7
Click here to choose the correct employee
Step #7: Click here to choose the correct employee

I will then enter the date from the receipt.

8
Choose the date that's on the receipt (note: this field defaults to the current day - you only need to change it if entering a receipt on a later date)
Step #8: Choose the date that's on the receipt (note: this field defaults to the current day - you only need to change it if entering a receipt on a later date)

I'll enter the name of the place where he bought gasoline.

9
Click on "Place of Purchase?" and type the name (in this case, "Maplefield")
Step #9: Click on "Place of Purchase?" and type the name (in this case, "Maplefield")

I can then type a brief description of what he purchased.

10
Click on "What was purchased?" and type a brief description. In this case, "Gasoline" suffices"
Step #10: Click on "What was purchased?" and type a brief description. In this case, "Gasoline" suffices"

Next, I click Insert, and my notation appears perfectly.

11
Click on "Insert"
Step #11: Click on "Insert"
12
Voila - your perfectly entered receipt:
Step #12: Voila - your perfectly entered receipt:

Then I need to click Recalculate, then Save and Close.

13
Click on "Recalculate"
Step #13: Click on "Recalculate"
14
Click on "Save & Close"
Step #14: Click on "Save & Close"

It will notify me that I have changed the transaction and ask if I want to save my changes.

15
Click on "Yes"
Step #15: Click on "Yes"

Example 2: Inserting a Charge Into a Group

I'm going to pull the bill back up.

16
Double-click on "Oct General Expense"
Step #16: Double-click on "Oct General Expense"

This is for curtains that Sandy bought on October 29th. I'll scan the bill again and locate Sandy's group. She currently has only one entry, which is at the top of the bill. It's a receipt from October 25th, and this new one is from the 29th. I need to insert this new receipt between her last entered charge and the first charge of the next person. To do this, click on the line below where you want this one to appear, which is also the first line of the next person's group, which is mine.

17
Click on the line immediately below where you want to insert a new one.
Step #17: Click on the line immediately below where you want to insert a new one.

Now, I'll go to the top menu bar, click Edit, and select Insert Line.

18
Click on "Edit"
Step #18: Click on "Edit"
19
Click here
Step #19: Click here

A new blank line appears exactly where you need it.

Now I repeat the same process as before. I click the Account field and make a selection.

20
Click here
Step #20: Click here

For curtains, I'll choose the "linens purchased" sub-account of Rental Expenses.

21
Click here
Step #21: Click here

Next, click the Amount field and enter the amount.

22
Click here
Step #22: Click here

Next, I’ll click into the Memo field and type /cce, which stands for Credit Card Entry. This activates the snippet. Then, I’ll select Sandy’s name from the dropdown.

23
Click here
Step #23: Click here
24
Type "/cce"
25
Click here
Step #25: Click here
26
Click on "Sandy (1875)"
Step #26: Click on "Sandy (1875)"

I will make sure the date matches the date on the receipt I am entering.

27
Click here
Step #27: Click here

The item was purchased from Black Forest Decor.

28
Click here
Step #28: Click here

"Curtains for Cabin 2" were purchased, so I'll type that as my memo and click Insert.

29
Click on "Insert"
Step #29: Click on "Insert"

Just like that, it types out the full memo notation.

30
Voila!
Step #30: Voila!

Now, click the Recalculate button, then select Save and Close.

31
Click on "Recalculate"
Step #31: Click on "Recalculate"
32
Click on "Save & Close"
Step #32: Click on "Save & Close"
33
Click on "Yes"
Step #33: Click on "Yes"

That's it. The process is simple if you follow the sorting rule and keep everything grouped by person and date.