Categorize by store after deposit

Strad · ‎April 08, 2019

We use the Store field to track sales. Early in our use of QBO a sale from a store was recorded as an added item on a deposit form. The store was not included. How can I find that item so I can add the correct store in the QBO directly. I've found a method that would require me to delete the original deposit item and replace it with a new transaction. I'd rather not have to make that kind of change for a simple change in description.

Strad · ‎April 10, 2019

Hi,

These are the steps to get to the split that has the option to add a Store:

1. "View Register" for the bank which received the item deposited without a Store.

2. Find the deposit which contains the item, along with all the other sales receipts and directly entered items for deposit.

3. Click on "Split". See the various accounts which received money.

4. After this view, the line changes so that only the boxes for date, memo, store, and reconcile can be edited.

5. Pick the desired Store from the drop down list of options.

See attached screen shot.

I'd like to add the store from this point. Will that add the picked store to all of the items associated with that deposit?

View solution in original post

HoneyLynn_G · ‎April 10, 2019

I appreciate the detailed steps and screenshot you provided, @Strad.

Yes, you're correct. When you change the store on the split transaction, it's applied to all items associated with that deposit. You can run and customize the following reports for Store tracking:

Profit and Loss by Store
Purchases by Store Detail
Sales by Store Detail
Sales by Store Summary
Store List

That should get you on the right track, Strad. Let me know how it goes or if you have any follow-up questions about deposit. I'll be here if you need further assistance. Have a good one.

View solution in original post

FritzF · ‎April 08, 2019

Welcome and thanks for reaching out to us in the Community, @Strad.

I'm here to help sure that this is taken care of, but I have some questions about your concern first.

So that I'm able to provide you with the best information, could you please let me know how you recorded the sale? Also, may I know what item you're referring? Is it a product and services or an account? Any additional information will be much appreciated.

You can click the Reply (green) button below to leave a comment.

I'll be keeping an eye out for your response and look forward to getting to the bottom of this. Take care and have a good one.

Strad · ‎April 10, 2019

I appreciate the help. The item I'm trying to change was created on a deposit form, in the "Add funds to this deposit" section. It was a cash deposit for raffle sales at an annual fund raiser. The account has been correctly applied.

I can find the deposit event, with all items, in the bank register. When I open the deposit for editing, there is an option at the top of the page, "Show payments for this store: " with a drop down box to pick a specific store or all stores. I don't see any way there to edit the store applied to the individual items.

Back at the bank register, when I click on "Split" I see a place to enter a "Store". Would this be a way to apply that store to the item without a store? What would happen to the other items that already have a store applied?

MaryLandT · ‎April 10, 2019

Thanks for providing additional details on your concern, @Strad.

In QuickBooks Online, you can only enter a store on your sales forms.

You can delete additional items on your deposit. Then, create an invoice or sales receipt instead to track the store for the individual items.

I'd also appreciate if you can attach screenshots of the place where you can enter a store after clicking the split. This is for me to get a better picture of the issue.

Thank you and I'll be waiting for your reply. Have a great day ahead.

Strad · ‎April 10, 2019

Hi,

These are the steps to get to the split that has the option to add a Store:

1. "View Register" for the bank which received the item deposited without a Store.

2. Find the deposit which contains the item, along with all the other sales receipts and directly entered items for deposit.

3. Click on "Split". See the various accounts which received money.

4. After this view, the line changes so that only the boxes for date, memo, store, and reconcile can be edited.

5. Pick the desired Store from the drop down list of options.

See attached screen shot.

I'd like to add the store from this point. Will that add the picked store to all of the items associated with that deposit?

Strad · ‎April 10, 2019

These are the steps to get to the split view of the deposit:

1. "View Register" for the bank that received the deposit of many sales receipts and direct entries, including the items entered without a store choosen.

2. Find the deposit entry in the register. See "Split" and click on it.

3. Temporarily see a pop-up of the accounts and money they received.

4. See that these fields have white boxes for edit changes: date, memo, store, reconcile. (See attached screen shot.)

5. Click in Store box to see a drop down list of available stores.

This is where I'd like to select the correct store. Will this change be applied to all of the items associated with that deposit transaction?

HoneyLynn_G · ‎April 10, 2019

I appreciate the detailed steps and screenshot you provided, @Strad.

Yes, you're correct. When you change the store on the split transaction, it's applied to all items associated with that deposit. You can run and customize the following reports for Store tracking:

Profit and Loss by Store
Purchases by Store Detail
Sales by Store Detail
Sales by Store Summary
Store List

That should get you on the right track, Strad. Let me know how it goes or if you have any follow-up questions about deposit. I'll be here if you need further assistance. Have a good one.

Topics

Training

Community

Resources

Categorize by store after deposit