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

Accounting

Hello,

 

I have recently been brought on to a company and I am trying to get all bills and payments back logged from all the way back in July. How do I enter bills and have them marked as paid if they came out of a debit card linked with the account or a check? I'm just trying to have everything logged in Quickbooks up to date, everything that I am entering is already paid. 

 

Thank you

6 Comments 6
Rustler
Level 15

Accounting

A bill only needs to be entered if it will be paid later.

Just enter the transactions. A debit card is linked to a checking account, so make the entry as a check, change the check number to EFT or DBT and select the expense account and amount paid.

Fiat Lux - ASIA
Level 15

Accounting

@zaczuk 

Prepare your Bills data

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125.13           

 

Prepare your Bill Payments data

RefNumberAPAccountVendorTxnDateBank or CC AccountPrivateNoteCurrencyExchangeRateToBePrintedBillApplyToLineAmount
2001 Staples#########CheckingBill Payment  N101375.53
3454 Green's Taxi Service#########CheckingBill Payment  N185125.13
321901 Federal Express#########CheckingBill Payment  N201264.07

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

zaczuk
Level 2

Accounting

How about if I am logging deposits that have already been deposited into the banking account? Basically I am just balancing everything on Quickbooks to what has been done to the checking account for the company

zaczuk
Level 2

Accounting

What about deposits? Basically I am just logging everything that has happened since July to match the checking account

ShiellaGraceA
QuickBooks Team

Accounting

Thanks for getting back to us, @zaczuk.

 

I'll share some information about balancing your checking account. You'll want to match your deposits with your QuickBooks transactions. Let me guide you how.

 

  1. Go to the Banking menu.
  2. Hover over Bank Feeds and select Bank Feeds Center to review the transactions.
  3. Tap your bank and then Sync this bank. This will download your latest transactions into QuickBooks.
  4. Open the Match Transactions window and from the Financial Institution dropdown, make sure the correct bank account is showing.
    1. Select View.
    2. Download and view the electronic statement.
    3. In the Match Transactions window, make sure the Show Register checkbox is marked.
  5. Pick the transaction in the statement that you need to match to a transaction in the register.
  6. Choose the transaction in the register to match it. Make sure the amounts match.
  7. Click Match.

 

For more details, please check out this article: Add and match Bank Feed transactions in QuickBooks Desktop.

 

With the above steps, you're able to balance your bills and payments with your bank statement and with QuickBooks.

 

I'm also attaching this link here to help you in reconciling your account: Reconcile an account in QuickBooks Desktop.

 

Don't hesitate to reply anytime if you have follow-up questions or concerns with bank accounts and QuickBooks. I'll be around to assist you. Take care and have a great day ahead.

Fiat Lux - ASIA
Level 15

Accounting

@zaczuk 

You may import Deposits with the following template

DepositToAccountLocationEntityLineDescLineAmountAccountPaymentMethodPaymentRefNumberClassCashBackAccountCashBackAmountCashBackMemo
Checking RobertDeposit 10Account1Cash     
Checking RobertDeposit 20Account1Check12345    
Checking RobertDeposit 30Account1Cash     

Need to get in touch?

Contact us