Skip to main content
Dec 21, 2021 7:37 PM UTC
Solved

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

I'm trying to export the detail, multiple rows, of a bank deposit into excel. Does anyone know if this is possible?
KlentB
KlentBAnswer
Dec 22, 2021 12:58 AM UTC

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.

3 replies

KlentB
KlentBAnswer
Dec 22, 2021 12:58 AM UTC

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.

Dec 22, 2021 9:52 PM UTC

This is exactly what I needed. Thank you Klent!

Fiat Lux - ASIA
Dec 22, 2021 1:12 AM UTC

@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