cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question about HMRC's VAT portal closure on November 1st? - Ask it here!
colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

I have downloaded my banking records from my Paypal and Buiness bank accounts however when i go to the For Review section of one of the accounts and select the correct category for the tranaction and click ADD. The transactions move to the Reviewed section but does not show up in my Expenses or Sales sections. How do i move transactions from the banking section to the Sales or Expenses tabs so i can view all my sales and transaction there?

13 REPLIES 13
Ashleigh1
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Hello Colinmcaleer, 

 

Welcome to the Community page, 

 

So it will depend on what type of transaction you are adding it as on the banking page. If you are doing it as a deposit/cheque then it won't show there. You should do either a sales receipt or expense, with a customer/supplier selected for them.

Or you can create manually and then matching it on the banking page. 

 

To match the transaction rather then add if you go to plus new top left-hand conder select expense fill in the details and save then go to the banking page and on that transaction, a match will show rather then add and it finds it by date, amount and account if all 3 are the same it will find the match on banking page for you.  

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Ok thank you very much for your reply but i'm not sure what you mean.  For my accountant to prepare my accounts I need to be able to show her a list of all my purchases and all my sales.  When I add details and select the category of my transaction the sale or purchases moves to the Reviewed section.  But nothing shows up in my Sales or Purchase Tabs.  Ive included a screenshot below of a sale that I categorised in my banking section, it can now be found in my reviewed tab for my bank.  As you see I have selected Sales as the Category.   For me to bring my accounts to my accountant I need to have a list of all my sales and expenses how do I get a transaction like this one below to show up in my Sales or Expenses Tabs so I can have a list of my sales and expenses?

Ashleigh1
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Hello Colinmcaleer, 

 

So the screenshot you sent is of a card credit this will not show on the all sales section as it is not a sales transaction it needs to be there an expense or a sales receipt to then show up on the all sales section in Quickbooks. 

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Not really sure why this shows as a card credit as this was a sale that was paid by the customer through PayPal,  So a for this transaction I cannot change the category from Card Credit to Sale and get it into the Sales tab?   What about the next screenshot below,  it was another transaction that I categorised as an expense and it has the same issue its in my Reviewed section but not the Expenses section

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

For reference ive included the screenshot of the Sales and Expenses tabs,  as you can see none of my transactions are showing up here?

Angelyn_T
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Thank you for the screenshots added, @colinmcaleer.

 

As long as the downloaded banking transactions were already added to QuickBooks and are showing up under the Reviewed column, they should show up either to your Expenses or Sales. The sales transactions include (Estimates, Invoices, Sales Receipts, Credit notes, Unbilled income, Recently paid, Money received, and Statements).b1 1.PNG

 

While (Expense, Bill, Bill Payments, Cheque, Purchase order, Recently paid, Supplier Credit, and Credit Card Payment) will show up for your expenses.b1 2.PNG

 

At this time, let's ensure that the banking transactions were already added to QuickBooks and only the transactions mentioned above will show up to either Expenses or Sales.

 

I've also added these screenshots for your visual reference.

b2 1.PNG b2 2.PNG

 

Let me know if you have any other questions. I'm always here to help. Have a good day

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

As you can see in the next few screenshots I have connected 3 banks and have items in the Reviewed section of each however none of these transactions are showing up in my Sales or Expenses Tabs

 

Screenshot 2020-05-12 at 13.22.40.png Screenshot 2020-05-12 at 13.22.53.png Screenshot 2020-05-11 at 17.38.29.png Screenshot 2020-05-11 at 17.38.35.png

Ashleigh1
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Hello Colinmcaleer, 

 

Thanks for the screenshots in the for review section in paypal can you click on one of the cc credit transactions and send me a screenshot of the page when it opens please so we can have a look at for you. 

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Thanks below are 2 CC Credit transactions.

 

 

 

Screenshot 2020-05-12 at 17.02.44.png Screenshot 2020-05-12 at 17.02.25.png

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Does anyone know is there a way to escalate my question to a supervisor at Quickbooks?,  i'm in my final days before accounts are due and i'm starting to panic that I won't get it done in time.

Ashleigh1
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Hello Colinmcaleer, 

 

Thanks for the screenshots, did you create the credit card credit and then match it on the banking page or did the system do it when you clicked on add on the banking sections?

colinmcaleer
Level 1

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

The system done this I did not select credit card credit.

Rasa-LilaM
QuickBooks Team

** HELP PLEASE ** How do i move transactions from banking section to the Sales or Purchases Section?

Thanks for adding more details about your concern, @colinmcaleer.


For transactions to show up in the Expenses or Sales section, I recommend following the suggestion provided by @Ashleigh1. The transaction should either be a sales receipt or expense with a customer/supplier associate with it.


We’ll have to open your company to determine why the categorized expense didn’t show in the Expenses Transactions page. From there, we can check what causes the transaction to automatically select as credit card credit.


However, I’m unable to perform the troubleshooting steps without asking for personal information. For the account’s safety, I suggest contacting our QBO Care Team.


One of our support specialists can review the downloaded data in a secure space. Once they’ve identified the cause and the solution, they will guide you on how to fix the issue.


Here’s how to get in touch with our support team:

 

  1. Go to the Help icon at the top to select the Contact Us link.
  2. This will open another window where you can enter the issue/topic.
  3. Once done, click on the Let’s talk button to view the support information.
  4. Choose how you want to contact our QBO Care Team: Start a chat or Call us.

Since you want to view all sales and expenses, you can run some reports to get the information. The Profit and Loss, Sales by Customer, or Sales by Account Reports will show the data you need.

 

  1. Tap the Reports tab on the left panel to enter any of the mentioned reports in the Search field box.
  2. From there, set the correct date to view the desired period.
  3. Click Run Report to view the changes.

For additional resources, check out the Customise reports in QuickBooks Online article. It provides an overview of how to use the Filter option as well as instructions to tailor the information on a statement.


Stay in touch if you have any other concerns or questions. I’ll be right here to answer them for you. Have a good one.

Need to get in touch?

Contact us