cancel
Showing results for 
Search instead for 
Did you mean: 
crystal-tucker11
Level 1

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?
Solved
Best answer December 21, 2021

Best Answers
KlentB
Moderator

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

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.

View solution in original post

3 Comments 3
KlentB
Moderator

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

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.

Fiat Lux - ASIA
Level 15

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

@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     
crystal-tucker11
Level 1

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

This is exactly what I needed. Thank you Klent!

Need to get in touch?

Contact us