cancel
Showing results for 
Search instead for 
Did you mean: 
Antique Dealer
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales

11 Comments 11
Adrian_A
Moderator

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Hello there, Antique Dealer.

 

You have me to help you set up a vendor in your QuickBooks Desktop file.

 

Let me guide you with these steps:

 

  1. From the Vendors menu, select Vendor Center.
  2. Click New Vendor and then New Vendor.
  3. Enter their information.
  4. Click OK.

 

Then, to record the daily sales, you can create a Bill. Here's an article that has the detailed steps to record a bill: Enter bills in QuickBooks Desktop.

 

I'll be around if there's anything that I can help with. Keep safe!

Antique Dealer
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

 hello 

that is not what im needing 

I have 11 venders in my store 

there items all have a tag with there number 

when a item sales i ring up in register with there number

at the end of the day i print a report from register that tells me 

how much each vender sold

how do i creat that end of day with totals for venders and sales in quickbooks desk top

DebSheenD
QuickBooks Team

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Thanks for getting back to us, Antique Dealer.

Let me share some information to help you accurately tracked your expense transactions.
 

You can create a journal entry to your income and equity account to keep track of the amount deposited to personal funds. Let me guide you how:

 

To set up the equity accounts.
 

  1. Go to Lists and choose Chart of Accounts.
  2. Click the Account button below and select New.
  3. From the Account Type ▼ drop-down, click Equity.
  4. From the Detail Type ▼ drop-down, find Owner's Equity or Partner's Equity depending on your situation.
  5. Then Save and Close.
     

Then create a journal entry.
 

  1. Go to the Company menu and hit Make General Journal Entries.
  2. On the first line, click the expense account for the purchase.
  3. Put the purchase amount in the Debits column.
  4. On the second line, choose Partner's equity or Owner's equity.
  5. Enter the same purchase amount in the Credits column.
  6. Select Save and close.


However, I'd suggest consulting an accountant. They can guide you on what accounts should be used to ensure your book is accurate.
 

For more insights about managing accounts and recording deposits in QuickBooks Desktop, you can refer to these articles: 

 


​​​​​​​Fill me in if you have any other questions about managing your sales. I'll be always around here in the Community to lend a hand.

SheAccounts
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Hello! I am searching high and low for just this same answer and the best way to organize / account these vendors and payouts. AntiqueDealer if you found a good method, and wouldn’t care to help a fellow SBO out, I would be very appreciative! 

camorris1231
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Me too.  I'm in the same situation.  Thank you.

 

Adrian_A
Moderator

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Hi camorris1231,

 

I appreciate you for posting in the forum. To ensure we're on the same page, can you share more details about your concerns? Are you trying to set up vendors?

 

I'll be keeping an eye on your response.

Rainflurry
Level 14

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

@camorris1231 

 

I assume that all of your vendor's inventory is on consignment?  If that's the case, you can track the sales by vendor by using the class feature in QB Desktop or Online as well as the sales rep feature in Desktop.  Unfortunately, you will need to manually enter it on each sales receipt. 

SheAccounts
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

Yes It’s consignment and there are so many vendors, I don’t know the best way to track it all. I have kind of given up on QB and I have received no help from QB their selves. My QB is so behind, I just keep holding all the info, not knowing how to put it in. On top of that… I linked square and it brought in every single transaction line by line (100s) and then when I put in a reciept, that duplicated the money bc I guess now I put in a sale AND so did Square. Customers can buy multiple items at a time (it’s an artists shop so it’s handmades, large and small items of all sorts… QB can’t purge the acct bc it’s been so long. I’ve learned a little more since April when I was seeking help but still have 0 bookkeeping done since April and welcome to tax season. FML. It’s been an awful experience for me, I mean it’s bc I don’t know what I’m doing but I am capable-just don’t know how to do it best. 

camorris1231
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

I too work at an antique store of sorts. We have 55 vendors.  

i see that I have several things to enter each month.

 

How do I enter each vendors monthly space rent?  I’m assuming I could do a recurring transaction?  Again how and to what accounts?

 

IDK if I’m going to enter it daily, weekly or monthly, but let’s say weekly. I need to enter the total shop sales, the portion of the sales that goes to the shop and the portion paid out monthly to the vendors for their sales, and maybe even sales tax payable.  How should I start doing that?

 

 Then on a given day during the month (15th) the shop pays our totals to each vendor for their monthly sales?  Again how and what accounts?

JamaicaA
QuickBooks Team

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

I appreciate the complete details you shared as you get back in this thread, @SheAccounts. I’ll offer a way to set up your vendors and track consignment sales in QuickBooks Online.

 

As per Rainflurry, we can use the class feature to track the sales by vendor. This will represent meaningful parts of your company, like store departments or product lines. If you haven’t enabled it yet, follow the steps below:

 

  1. Go to Settings and select Account and settings.
  2. Navigate to Advanced tab.
  3. In the Categories section, select Edit ✎ to open the fields.
  4. Select the Track classes checkbox.
  5. Click Save and close, then Done.

 

After that, let’s enter your consignors as vendors:

 

  1. Go to Get paid & pay and select Vendors
  2. Select New vendor.
  3. Enter the consignor's information in the Vendor information.
  4. Click Save and close.

image.png

 

Next, you’ll need to assign each of your consignors to a Class for reporting purposes. I’ll show you how:

 

  1. Go to Settings and select All Lists under Lists.
  2. Select the Classes item to open the Classes page.
  3. Click New.
  4. Enter the consignor's Name in the Class dialog.
  5. Hit Save.

download.png

 

Once done, visit this article and proceed to 2. Set up consignment income accounts to help track consignment sales and payouts: How to record consignment sales. This includes the detailed instructions of recording them and creating its report.

 

Moreover, I highly recommend seeking professional help to your accountant. This way, we can ensure your consignment sales and payments are properly recorded.

 

Also, when running reports for a consignment, you can check the articles below for more details:

 

 

Let me know if you need further assistance with tracking consignment. The Community always has your back. Wishing your business a wonderful success.

SheAccounts2
Level 1

I have a Antique Store I need to know how to set up venders that sell there items in my store and how to record the daily sales with there vender number

@Antique Dealer @camorris1231 I hope you all are doing well. [email address removed] is my email. Maybe we can discuss something together. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us