cancel
Showing results for 
Search instead for 
Did you mean: 
jbnichols0709-gm
Level 1

I have found how to input expenses manually. Is there a way to do the same with deposits?

I have 3 months of missing bank data from the beginning of the year. I have tried manually updating my banking info, and reconciling, and my bank does not offer CSV versions of banking data (only PDF). I have been manually entering the missing transactions, but can't figure out how to do the same for the deposits and payments made to us.
2 Comments 2
Jovychris_A
Moderator

I have found how to input expenses manually. Is there a way to do the same with deposits?

I appreciate the details that you've shared, @jbnichols0709-gm.

 

I've got some info to share and able you to work with CSV files.

 

You can enter the bank statement data like the deposits, payments, and expenses in an Excel format and save it as a CSV(comma delimited) file. There are two template formats that QBO supported.

 

3 Columns

The 3-column template has columns for the Date, a Description of the transaction, and the Amount of the transaction. Where a deposit shows a positive amount, and credit indicates a negative amount.

 

4 Columns

The 4-column template has a Date column, a Description column, and both a Credit and a Debit column.

 

These are the columns QuickBooks supported when importing bank transactions.

 

Here's how you can save it as a CSV file in Excel:

  1. Click the File menu and then select Save as.
  2. Click Browse (folder) and then put it in a place that you can easily see it, like Desktop.
  3. Enter the file name.
  4. Then on the Save as type drop-down list, select CSV (Comma delimited).
  5. Hit Save.

 

Once done, sign in to QuickBooks and then follow these steps to import the bank data file. Make sure to review the format on the CSV file to prepare for the upload.

  1. Go to Settings and then select Import data under Tools.
  2. Select Bank data.
  3. Click Browse and then open the CSV file.
  4. Choose Next, then choose a bank account.
  5. Select Next, make sure the dates, descriptions, and amounts are in order.
  6. Then click Next and review the CSV data, then Next.
  7. Click Yes to confirm the transactions.

You can see the steps and other details through this article: Import bank transactions using Excel CSV Files.

 

With these steps, you get your missing bank transactions uploaded and able to categorize, match, or add them in QuickBooks.  Also, you can add other details from there.

 

Let me jump in and assist you if there's anything else you need help. I'll answer as fast as I can. Have a safe day!

 

Fiat Lux - ASIA
Level 15

I have found how to input expenses manually. Is there a way to do the same with deposits?

@jbnichols0709-gm 

Utilize trial trial period of TP to import your data in bulk.

https:// transactionpro.grsm.io/qbo

 

Prepare your data with the following templates

 

Receive Payments (against your invoices)

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100,00   
228/11/20204908Leonard Walker IncCheckChecking102138,78   
328/11/20204908Lisa SmithCheckChecking103126,50  

 

 

 

 

Deposits

RefNumberTxnDatePrivateNoteCurrencyExchangeRateDepositToAccountLocationEntityLineDescLineAmountAccountPaymentMethodPaymentRefNumberClassCashBackAccountCashBackAmountCashBackMemo
112/12/2020 USD Checking RobertDeposit 10Account1Cash     
112/12/2020 USD Checking RobertDeposit 20Account1Check12345    
112/12/2020 USD Checking RobertDeposit 30Account1Cash     
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us