Export excel sales deposits into quickbooks premier desktop

You can prepare the Sales Receipt data with the following template

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Hmm interesting..

Can I be more descriptive here its simply only a cash deposit so it would look something like this.

8/1/2021 $500.00 General Checking cash

8/2/2021 $350.00 General Checking cash

but a full months spreadsheet of this.

8/1/2021 $500.00 CASH GENERAL CHECKING

8/2/2021 $350.00 CASH GENERAL CHECKING

these would be deposited into the general checking account for the entire month. We do this only once a month is there a easy to get this little bit of info exported to QB

You only need to prepare the Ref Number, Customer, and Bank Account data as mandatory fields for Sales Receipt data and leave the other fields blank. 

Another option, prepare your Deposits data with the following template and utilize the importer tool.

@cor4eyh 

Yes, if you have an Excel spreadsheet that lists daily deposits, you can import them using our BRC IIF Transaction Creator .

You'll basically include the same fields in Excel as you do on the deposit. Your worksheet will look something like this, though you can add additional columns if you use additional fields on the deposit, like class or name: