Skip to main content
December 21, 2021
Solved

Is there a way to export bank deposit detail into excel?

  • December 21, 2021
  • 2 replies
  • 0 views
I'm trying to export the detail, multiple rows, of a bank deposit into excel. Does anyone know if this is possible?
Best answer by KlentB

Hi there, crystal-tucker11.

 

You can definitely export the Bank Deposit Detail report. It will just take a few clicks to do it. I'll show you how:

 

  1. Go to the Reports menu.
  2. Under Sales and customers, choose Deposit Detail.
  3. Click the Customize button.
  4. Set the appropriate reporting date and accounting method.
  5. Add or remove the columns from the Rows/Columns section as desired.
  6. Click Run report, then select the Export icon.
  7. Choose Export to Excel.

I also recommend checking these articles to help speed up the reporting process in QuickBooks Online:

 

Keep me posted if you need more help in completing your other tasks.

2 replies

KlentB
KlentBAnswer
December 22, 2021

Hi there, crystal-tucker11.

 

You can definitely export the Bank Deposit Detail report. It will just take a few clicks to do it. I'll show you how:

 

  1. Go to the Reports menu.
  2. Under Sales and customers, choose Deposit Detail.
  3. Click the Customize button.
  4. Set the appropriate reporting date and accounting method.
  5. Add or remove the columns from the Rows/Columns section as desired.
  6. Click Run report, then select the Export icon.
  7. Choose Export to Excel.

I also recommend checking these articles to help speed up the reporting process in QuickBooks Online:

 

Keep me posted if you need more help in completing your other tasks.

December 22, 2021

This is exactly what I needed. Thank you Klent!

Fiat Lux - ASIA
December 22, 2021

@crystal-tucker11 

Like this one?

RefNumberTxnDatePrivateNoteCurrencyExchangeRateDepositToAccountLocationEntityLineDescLineAmountAccountPaymentMethodPaymentRefNumberClassCashBackAccountCashBackAmountCashBackMemo
112/12/2020 USD Checking RobertDeposit 10Account1Cash     
112/12/2020 USD Checking RobertDeposit 20Account1Check12345    
112/12/2020 USD Checking RobertDeposit 30Account1Cash