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

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check. 

The paperwork lists the total sales, deductions for rent, subscription to online sales, percentages and sometime advertising. It is one check, so plus and minus, I have tried all kinds of ways to enter, but it wont let me do both in one transaction??? Thanks for any help...I really miss my reports and I have redone the deposit/deductions several times...Tax time is coming, nightmares!!

Solved
Best answer December 06, 2021

Best Answers
Rainflurry
Level 13

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

The easiest way is to create a deposit (Banking>Make Deposits).  Select your bank account and use whoever the check is coming from as "Received From".  In "From Account" and "Amount", enter:

 

Sales, $2000

Rent Expense, negative $140 (include the $60 for 3% if applicable)

Gateway Fee Expense (or whatever applicable expense account), negative $2

 

The deposit subtotal should be $1,780, click Save & Close. Done.

View solution in original post

5 Comments 5
LollyNino_C
QuickBooks Team

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

Hello there, @nanasnecessities

 

I'd be happy to lend you a hand and help guide you on how to record reports in QBDT.

 

We can run the Transaction List by Customer report and customize it to get the information you want to achieve. Here how:

 

  1. For the Reports menu, choose Customers and Receivables.
  2. Select the Transaction List by Customer.
  3. From the Dates drop-down menu, choose Last Month or This Month.
  4. Click Customize Report and select the Filters tab.
  5. Search for Transaction Type, and select Invoice.
  6. Search for Paid Status, and select Closed.
  7. Click OK.

For your reference, you can visit these resources for more customization techniques on the different reports that you can pull up in QuickBooks Desktop: 

Lastly, I've got you this helpful article to learn more about how you can memorize a report: Create, access, and modify memorized reports.

 

Know that you can always visit me here if you have any other questions about your reports. I'll be around to address them for you. Take care!

nanasnecessities
Level 1

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

I am having trouble figuring out how to enter my transaction.

example: Total Sales: $2000.00

They take out my rent, $140

They take out a gateway fee of $2.00

They take out a percent of my total sales of 3%, this example $60

I have a check for $1798.00 

How can I deposit this check and still show the $140, $2.00 $60?

I have tried this so many ways and cant get it to work out unless I run it through cash, it is screwing up my checking any other way. I cant get it to do a sales or invoice because of the positives and negatives, I need it to work for my reports, but I need my bank to balance also. Each one I am in has different rent and charges. So at the moment, I am entering it under cash as a bank. each and every one as a separate transaction and I know there has to be a way to do this?

Rainflurry
Level 13

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

The easiest way is to create a deposit (Banking>Make Deposits).  Select your bank account and use whoever the check is coming from as "Received From".  In "From Account" and "Amount", enter:

 

Sales, $2000

Rent Expense, negative $140 (include the $60 for 3% if applicable)

Gateway Fee Expense (or whatever applicable expense account), negative $2

 

The deposit subtotal should be $1,780, click Save & Close. Done.

nanasnecessities
Level 1

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

I really felt that it should be an invoice or sales receipt, but this will work for my banking and my reports. I sell many small items so I am not entering individual items from each and every vendors mall, I am in 5 at the moment, so it would be a chore.

Angelyn_T
QuickBooks Team

I have switched from retail to Vendors malls, my sales are great, but I am having trouble figuring out how to record the end of the month check.

I appreciate you for getting back, @nanasnecessities. Allow me to join the thread and share with you some additional information about recording your sales in QuickBooks Desktop (QBDT).

 

Yes, you can use invoices or sales receipts for your sales entries aside from bank deposits. The recording depends on the mode of your transactions. 

 

A sales receipt is used when your customer pays you on the spot for goods or services. An invoice is used when sales are paid at a later time. You can set up terms to indicate how long the customer has to pay. When you're ready to record a payment and make a deposit, use these articles as your guide:

 

 

On the other hand, you can always ask your accountant for more options in tracking your sales transactions. He or she can provide you with other ways while keeping your books in place.

 

Additionally, here's how you can get more hints while handling your customer entries in the future: Get started with customer transaction workflows in QuickBooks Desktop.

 

If you have any other follow-up questions about recording your sales, let me know by adding a comment below. I'm more than happy to help. Keep safe!

Need to get in touch?

Contact us