Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello,
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
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.
Prepare your Bills data
RefNumber | APAccount | Vendor | PrintOnCheckName | TxnDate | DueDate | SalesTerm | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Supplies | For Anne | 25.1 | ||||||||||||||||||||
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Telephone | Phone Cards | 50.25 | ||||||||||||||||||||
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | MP3 Player | Blue MP3 Player | 2 | 55 | |||||||||||||||||||
185 | Green's Taxi Service | ######### | Net 30 | 1 Main Street | San Diego | CA | 12345 | Transportation | 125.13 |
Prepare your Bill Payments data
RefNumber | APAccount | Vendor | TxnDate | Bank or CC Account | PrivateNote | Currency | ExchangeRate | ToBePrinted | BillApplyTo | LineAmount |
2001 | Staples | ######### | Checking | Bill Payment | N | 101 | 375.53 | |||
3454 | Green's Taxi Service | ######### | Checking | Bill Payment | N | 185 | 125.13 | |||
321901 | Federal Express | ######### | Checking | Bill Payment | N | 201 | 264.07 |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
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
What about deposits? Basically I am just logging everything that has happened since July to match the checking account
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.
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.
You may import Deposits with the following template
DepositToAccount | Location | Entity | LineDesc | LineAmount | Account | PaymentMethod | PaymentRefNumber | Class | CashBackAccount | CashBackAmount | CashBackMemo |
Checking | Robert | Deposit | 10 | Account1 | Cash | ||||||
Checking | Robert | Deposit | 20 | Account1 | Check | 12345 | |||||
Checking | Robert | Deposit | 30 | Account1 | Cash |
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.