Combine Daily Sales and Prepare csv to import into Quickbooks Online for journal entries

[mjcanty]

I have a file that I download from our payment processor that contains each sale on its own row. The data consists of the sales date, the amount of the total sale, the associated fees, and the net deposit amount. Columns C-E are the fees and the majority of the time, columns D and E are either zero or blank because those fees were not applicable. Ideally, I would like the three fee cells to be aggregated into its own cell. I would also like all sales completed on one day to be aggregated so that each day is shown on one row. Lastly, I need a csv file to import into Quickbooks Online for journal entries. The csv file needs a column for the journal entry number, followed by the date, the total sales for that day, which in the chart of accounts is named Service Revenue and is a credit account; followed by the Processing Fees, which in the chart of accounts is named Payment Processing Fees and is a debit account; and the NetSettledAmount, which in the chart of accounts is named Boulevard Clearing Account and is a debit account. If it is possible, I would like there to be a message prompt asking what the beginning number should be for the journal entry. Ideally, the journal entries would be in ascending order as well as the date field. Thanks in advance and I hope I didn't make this terribly confusing.

 

[Joe4]

I think I may be able to help you with at least some of your steps, but I am not about to manually type in all your data to recreate your scenario to work from. Can you post some sample data in a format that we can copy/paste to our side?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.