Credit Card Reconciliation ** Needs updating**

Credit Card Reconciliation ** Needs updating**

Credit Card reconciliation  

We have three Amex CC card and 2 Chase CC card

Each CC card has their own due date for bank statement. You could reconcile the CC cards at the end of each month or categorize each transactions  in advance when it’s available.

How to do the CC reconciliation ?

  1. Click on Banking

  1. Click on the account you want to reconcile.

  1. Categorize each line item. After you have categorized the line click add, or match to add the line to the register

  1. After all transactions have been categorized click on the “Go to bank register” button

  1. Click Reconcile

  1. Put in the ending balance and ending date from the cc bill

            

  1. Check mark each transaction that is on the statement.

 

    ● Check for review-check each category item

How to categorize each transaction

Vendor’s name

Category (which account it should be. If it is CR-CY intercompany payment , use this account ) , Class (which brand, optional),

department

memo

    ● add

If the QBO add automatically , go back to

Repeat the same steps for categorize the transactions.

    ● Reconcile -find credit card account- double check the opening balance and ending balance (entry amount) , and date-check all the transactions and make sure the difference is zero – reconcile button -print the reports.

    ● Put the summary in the front and details in the next

    ● Put the documents in the drawer name (A/P, the third one)

 

Bank Reconciliation (Chase, CP)

You can start with either Cypress or Crittenden, whichever you prefer.

Go to Chase/DL Evans

Download transactions from the month of March in QBO File

Go to QB Online

Go to Banking

Click Upload Transactions

Drag the .qbo file here.

Go through each transaction and add any information that you need. We’ve done this a few times, let me know if you need any help recalling! Mary is also a good resource if you have questions about transactions. You can also check your manila folder with the bank receipts and invoices to help you

 

    ● Bank account-download the transactions (from recent date) into QuickBooks

    ● Open QB-bank feed-import-unrecognized -add more details

    ● Merchant card-cardpoint-gateway batches -click the related amount batch No & dates ,search transaction No- make category with related payee

    ● Find related Order ID in QB (match to existing transactions), if not, open Maghub, Search for the Order ID, add customer information into QB. If already been Paid , ingore

    ● Find related transactions invoice R

    ● If is not in QB or Magehub, input all the information .

    ● Ignore ADP tax (exclude)

    ● Ignore ADP payroll(exclude)

    ● ADP process fee ,record category as ADP process fee

 

House  

    • Related Articles

    • Digital Marketing Responsibilities **needs updating**

      Digital Marketing Responsibilities General Overview Advertising should be in place and ready to run before the first of the month. Double check to make sure things are set up correctly. Advertising in newsletters is organized first come, first serve. ...

    • Tracking Bonuses *Needs Updating*

      Tracking Bonuses Table of Contents Link to Main Section 1 Other Details Overview of the SOP – This is for tracking Bonuses for commission based Sales People. Resources Cypress Sales & Bonus Tracker on Google Drive. Main Section 1 Search for “Cypress ...

    • Customer payment portal *needs updating**

      Customer payment portal ∙ Reset the password from Maghub under contacts-select the personal name ∙ Make sure the invoices and bills (payment) checkboxes are checked If it is checked , this person has the right to access the portal . Email :” I will ...

    • Conference Event Wrap Up *Needs Updating*

      Overview of the SOP - Describes the steps to gather data and enter into Event Wrap Up Template. Resources Event Wrap Up Template: https://sheet.zoho.com/sheet/open/tb70304b6c127952043c8b67f86e90954f266?sheetid=0&range=A1 Master Conference Program ...

    • Reconcile Heath Insurance in spreadsheet *needs update*

      Reconcile the health insurance in spreadsheet At every beginning of month, we will receive the bill from regence for next bill coverage period. We normally do the insurance reconciliation at beginning of each month. 2. add up the two pay period ...