cancel
Showing results for 
Search instead for 
Did you mean: 
Randy6
Level 2

credit card

I have received Jan-May credit card statements from a client.  There are 2019 charges that were not included in 2019 totals.  How to deal with this?

4 Comments 4
Mark_R
Moderator

credit card

Hi there, @Randy6.

 

You can manually add the 2019 transactions so they'll be included in the 2019 totals. Let me guide you through the steps.

 

Before we start, please make sure that the current dates aren't reconciled. This way, the reconciliation of the account won't mess up.

 

To proceed, you can write a check for the charges and make sure to enter the 2019 date. Here's how:

 

  1. In your QuickBooks Desktop account, go to the Banking menu and select Write Checks.
  2. Select the appropriate bank account from the drop-down.
  3. Choose the payee in the Pay to the Order Of drop-down.
  4. In the Expenses section, select the account. Or the items from the Items tab.
  5. Fill out the necessary information, then click Save & Close.1.PNG

Once done, you can manually mark the transaction as reconcile if it's already reconciled from 2019.

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Select the appropriate account from the list.
  3. In the transaction list, select the created transaction and mark it as reconciled by putting a checkmark in the Check icon column.
  4. Click Record.2.PNG

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a great day and keep safe.

Fiat Lux - ASIA
Level 15

credit card

@Randy6 

As anoter option, utilize the trial period of these importer tool.

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

You should prepare the template like this as CC Charge

Credit Card AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableCurrencyExchange Rate
QuickBooks Credit CardBarnes and Noble01/09/20201 1 Main Street   AnytownNY12345USA Misc Supplies100             
QuickBooks Credit CardMcDonald's03/09/20202 1 Jones Street   AnytownNY12345USA Meals25  ABC CompanyY         
QuickBooks Credit CardJoe's Taxi05/09/20203 1 Felt Ave   AnytownNY12345USA Transportation200             

 

Randy6
Level 2

credit card

What if the 2019 taxes have already been filed?

Jovychris_A
Moderator

credit card

Thanks for your prompt response, @Randy6.

 

There are two ways to deal with taxes when entering prior charges. You can write a check for the expense when the Tax Due payable for 2019 is not in QuickBooks. You can follow Mark_R's steps in dealing with it. And, if you see the tax due payable in QuickBooks, then you can utilize the Sales Tax payment feature.

 

Let me show you how:

  1. On the Home page, click Manage Sales Tax.
  2. Click Pay Sales Tax. The Pay Sales Tax dialog box opens.
  3. From the Pay From Account drop-down list, select the bank account to deduct the sales tax payment from.
  4. In the Check Date field, type or select the date to print on the check.
  5. In the Show sales tax due through field, type or select the period end date for the tax period.
  6. In the Starting Check No. field, accept the default check number or assign a check number as appropriate.
  7. Click on the sales tax items to be paid. If you need to make a payment for less than the full amount, edit the value(s) in the Amt. Paid column.
  8. Review the information, then click OK.

 

You can always get back to this post if you need further assistance. I'll keep my notifications open. Have a good one!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us