Categories
Bank Register Credit Card Vendor Vendors

How to manually add few missing credit card transactions that were not in bank feed

How to manually add few missing credit card transactions that were not in bank feed

For missing bank feed credit card transactions, you should be able to manually enter bank transactions directly to the Credit Card Register in QuickBooks.

Here is how to manually enter my credit card transactions without downloading from the Bank.

From the Left Dashboard | Accounting |Chart of Accounts

Select the Credit Card account in question.

Click “View Register” under Action column.

(You’re now on Bank Register).

Select “Add CC Expense” from the drop-down arrow (right below Date column).

Enter transaction information and save.

It will automatically update the running balance.

Categories
bank feed Credit Card Excel Spreadsheet File upload Import Data

How to import credit card transactions from Excel CSV file to QuickBooks Online (QBO)

QuickBooks Online allows users to import their credit card transactions via Excel CSV (comma-separated values) files. It will allow importing date, description and amount columns. For the amount, you can use 1-Column field or 2-Column fields. It is recommended to use Debit and Credit with two columns excel file format to import. QBO will not allow mapping additional columns, for example, billable to customer, class, and location.

QBO uses the same “Map CSV columns” fields format for importing both bank account as well as credit card account. It’s a bit confusing for importing credit card liability type account. It could be ended up importing the wrong way. For bank checking account import, you will need to use opposite fields selection of credit card import. Like for example, the expenses were imported as payments and vice versa. See below instructions on how to correct if that happens.

Here is recommended Excel CSV template format:
Debit = Expense
Credit = Payment

 

To import a CSV file (see below for screenshots):

    • From the left dashboard, select Banking.
    • Select File upload at the top right corner.
    • Click Browse and Select the “.CSV file” to upload from your computer.
    • Click Next.
    • From the QuickBooks Account drop-down, select the credit card account to which to import.
    • Click Next.
    • Map your fields according to your CSV file’s format.
    • Under Amount, Select 2 Column radio-button.
    • For Debit Column 3, Select Expense and for Credit Column 4, Select Payment.
    • Click Next.
    • Select the transactions to import.
    • Click Next.
    • You will receive a notification, stating the number of transactions that will be imported.
    • Click Yes.
    • When you get confirmation of the import, click Finish.

     

    You will now be directed to the Downloaded Transactions window under Banking, where the imported transactions will appear under the “For Review” tab. You will now need to review account category and appropriate payee and add the transaction to QuickBooks.

     


     

    How to delete the transaction imported from bank feed if they were imported wrong way?
    Like for example, the expenses were imported as payments.

    You will first need to exclude and then delete all the transactions.

    To exclude a transaction or multiple transactions:

    • Choose Banking on the left dashboard.
    • You’ll see the For Review tab, click the checkboxes to the left of the date for the transactions you want to exclude.
    • Once you’re done, click the Batch Actions drop-down arrow and select Exclude Selected.
    • The transactions move to the Excluded tab.

    To permanently delete unwanted downloaded banking transactions from “Excluded” section of the banking center

    • From the Excluded tab, go to “Batch actions” and choose to pull down arrow and select DELETE. That will permanently delete downloaded transactions.

    Screenshots of CSV file upload:



     


Categories
Chart of Accounts Credit Card

Why is my credit card beginning balance negative

You will first need to check the account TYPE in the Chart of Accounts.
If you’ve manually entered the credit card balance as a positive number when, creating a new account in the Chart of Accounts, on reconciling screen, your beginning balance should also be positive, not negative.

You will need to check the TYPE on your chart of accounts. For credit card account, the CATEGORY TYPE should also be “Credit Card” not Bank or something else. If it’s not setup as credit card type, you will need to edit from pull-down arrow next to view register in the chart of accounts.

coa-credit-card-type
coa-credit-card-category-type