Quickly Getting Credit Card Data into QuickBooks

[debbiekilz]

Thank You!!! Do you have anything in mind I could help you with? I am always open to new ideas for new videos!

All the videos I have created are requests from clients and colleagues. So please ask away!

Debbie

[tmsibusinessphones]

@debbiekilz

Thanks for this excel tip! the ifsum is pretty cool. as a followup I have a question....

how do you post multiple entries that are the same account in the G/L? do you sum them in another excel spreadsheet?

[tmsibusinessphones]

for instance I might have 100 entries per month per credit card, obviously many for automotive expense like fuel, etc etc.... do you just rekey them as they appear on the statement and the ifsum totals each like expense to the total of that G/L # ?

Also did you come up with a way to extract tax from the purchase if the tax is a deductible tax that can be claimed as an input tax credit ? (you may not have to deal with that element)

[jh90713]

This video was over my head but I realize that you have a great voice for this.

Please make more QB Videos.

[jcomments8]

Great tutorial!!! Thank you for teaching about SUMIF too!