Bank feeds history and assigning appropriate account

I would love to help you with your concern about your ecommerce bank transactions, @nitsujayyy.

For me to provide the best resolution to your issue, I need more information about it. Are the transactions you're having a problem with already uploaded to QuickBooks Desktop? Also, I would love to have further information about these transactions you need to assign. A screenshot would be much appreciated as well so we can give you an efficient resolution.

Don't hesitate to comment below for further information. I'm always here to help. Have a great day.

Trying to back this out and associate it with proper account 

Undoing a categorized transaction isn't possible in QuickBooks Desktop (QBDT), @nitsujayyy.

If you have added and categorized the transaction in your bank feeds, it can't be undone. The only way to reverse this is by deleting these entries and reimporting them to your QBDT company account. I'll walk you through the process of accomplishing this.

To delete a transaction, here's how:

1. Head to the Banking menu.
2. Select Bank Feeds then Bank Feeds Center.
3. Choose the Bank account and then click Transaction List.
4. Mark all transactions you need to undo.
5. Go to the Batch Actions dropdown and select Ignore to delete.

After removing those, let's go ahead and upload these entries. You can follow the steps I'll share below.

QBDT offers two ways to download your transaction. You can select either of these two:

• Direct Connect
• Web Connect

Please read this article for reference and additional information: Download bank feed transactions in QuickBooks Desktop.

At the same time, I would like to ask for further information about this concern. I would appreciate it if you could provide us with some screenshots since it will help us give an accurate resolution to your issue.

Also, I've added this article you can check out to guide you in handling bank transactions in QuickBooks: Add and match Bank Feed transactions.

Get back to this post if you have further questions about backing out and associating your account with its correct place. I'll always got your back

So question. I have to do a year worth of reconciliation because I lost file. It’s not too much transaction, but how can I pull past data? Importing?

with webgility, it makes a AR I make from Shopify. When I see the amount in bank how do I basically associated with payment?

Let me join the thread and help you with your concern, nitsujayyy.

If the transactions showing were brought as AR and posted to the Undeposited Funds account, we can link it to open invoices. But if the invoices are lost, you'll need to recreate them.

To link the open invoices, here's what you'll need to do:

1. From the Customers menu, select Receive Payment.
2. Select your customer from the Received from drop-down.
3. Choose the Discounts and Credits icon.
4. On the Credits tab, check the credit you want to apply and then Done.
5. You may see a prompt to confirm the transfer. If you do, select Yes. The amount will be applied automatically to the invoice.
6. Select Save & Close.

However, if the transactions are not yet in QuickBooks Desktop (QBDT), you can import them as IIF or .QBO file and post it to the right account. For more details, see this article: Import and export data in QuickBooks Desktop.

We're always here ready to help if you still have other questions about managing your transactions. Just leave a reply below, nitsujayyy.

Here's my customer center

Here's my bank feed.

Can I select the payee as my customer would that clear it?

I made reply. I meant the bank fee matching up with the customer payment basically

Thanks for coming back here, @nitsujayyy.

I'll share more info about matching invoices and bank transactions.

Yes, you can select a payee as your customer to clear the invoice, as long as the account is associated with Account Receivable (A/R).

Concerning your bank feeds, after receiving the invoice payment, match it to the deposit that shows on the banking feeds. Here's how:

1. Go to the Banking tab.
2. Select Bank Feeds Center from the Bank Feeds tab and review the transactions in each category.

There are different modes to match transactions in the bank feeds. You can choose either of the options below:

• Express mode
• Classic mode
• Advanced mode
• Manually match transactions

For more info, check out this article: Add and match Bank Feed transaction in QuickBooks Desktop.

You can read this article if you want to categorize transactions via rules: Create rules to categorize transactions in QuickBooks Desktop.

Click the Reply button below if you have additional questions about matching transitions. We'll be willing to lend a hand. Have a good one.

This part I understand. I meant so the transaction in bank feed? How do I assign them? My Shopify sales comes in as AR so it will always have an overdue unless I close it. Shopify sometimes breaks out the charge from each order. So in bank feed I would see the Shopify sales, how can I record it? Do I record it to bank and then receive payment?

Hello there, nitsujayyy!

When it comes to recording Shopify sales in QuickBooks Desktop, you need to pay attention to a lot of details such as income, deductions, and fees for the relevant payment gateway. By recording this information in QuickBooks, you can reconcile the amounts reflected in your bank account.

Here's the workflow for recording Shopify sales in QuickBooks Desktop:

1. Install QuickBooks Connector
2. Generate Integration Token
3. Map Accounts and Data
4. Choose Sync Mode
5. Enter API Key
6. Run Shopify Payout Report
7. Run Shopify Finances Summary Report
8. Import Data into QuickBooks
9. Use Link My Books
10. Reconcile Data

Once the initial setup is complete, you can schedule recurring imports of Shopify sales data to keep your QuickBooks Desktop records up-to-date. This will streamline the process and ensure your accounting records stay synchronized.

Keep in mind that the specific steps may vary slightly depending on the version of QuickBooks Desktop you are using and the configuration of your Shopify integration.

Also, for a comprehensive understanding of how to add and match Bank Feeds transactions, I highly recommend referring to the article: Add and match Bank Feed transactions in QuickBooks Desktop. This resource provides a detailed list of processes that cover Bank Feeds in QuickBooks.

You can count on me to assist with anything else you need to manage your transactions using QuickBooks Desktop. I'm always ready to help. Have a great day!

A bit confused. So right now I'm registering all the feeds from my bank.

As im registering it, do I first make the payee in bank fee to my customer name? What about the Account that it's going to? Sales or AR?

Here you can say I have a software that imports all orders from customers and has them as AR. If I receive the payment, it would  make a line that says undeposited funds? Is this the correct way?

If this is correct, so be it, but im curious why it goes to undepositied funds? Wouldn't it create extra revenue?

I appreciate your efforts thus far, @nitsujayyy. You're on the right track. Let's work together in assigning imported Shopify transactions to appropriate accounts in QuickBooks Desktop (QBDT).

You can choose the customer's name and select Sales account in response to your first question. However, manually registering or adding the imported Shopify transaction doesn't link it to the received payment posted in the Undeposited Funds (UF) account.

In response to your second question, the UF account is a temporary holding account for multiple transactions before they're combined to match the real-life bank deposit. For more information about the function of the UF account, you can visit these articles:

• What’s the Undeposited Funds account?
• Deposit payments into the Undeposited Funds account in QuickBooks Online.

Based on your screenshots, it would be best for the received payments to be posted directly to the bank account where the imported Shopify transactions are instead of the UF account. To accomplish this, change the default posting account of the received payments. Here's how:

1. Go to the Edit menu in your QBDT. Then, choose Preferences.
2. Select Payments on the left navigation panel.
3. Click on the Company Preferences tab.
4. Uncheck Use Undeposited Funds as a default deposit to account.
5. Hit OK.
   

Once done, update the posting account of the received payments. You can follow these steps:

1. Go to the Customers menu. Then, select Customer Center.
2. Click on the customer at issue.
3. Double-click on the Receive payment transaction.
4. Choose the appropriate bank account from the Deposit To drop-down list to assign it to the correct bank account.
5. Repeat steps one to four for the rest of the received payment transactions.

You can then match the received payment transaction to the Shopify transaction to avoid duplicate recording. Please refer to the Manually match transactions section of this article for the detailed steps: Add and match Bank Feed transactions in QuickBooks Desktop.

I'm also adding this article as a guide in reconciling accounts in QBDT as a future reference: Reconcile an account in QuickBooks Desktop.

Keep us posted if you have further updates assigning transactions to the correct accounts in QBDT. We'll do our best to assist.

Yes this helped! Now question is too in shopify, sometimes they combine 2 different customer as total. How would I be able to seperate it?

Thanks for getting back in the thread, @nitsujayyy.

Allow me to chime in and provide additional information about bank transaction in QuickBooks Desktop (QBDT).

Regarding your concern with the bank transaction, QuickBooks relies on the information shared by Shopify, if the data don't combine two different customers, we can manually enter them using the downloaded files. But please note that if this data is saved as a zip or compressed file, extract it first to integrate it into our bank transactions.

Lastly, I've included these resources to help you review your downloaded bank and credit card transactions and automatically categorize transactions from your bank:

• Download bank feed transactions in QuickBooks Desktop.
• Add and match Bank Feed transactions.

If you have additional questions about managing your Shopify in QBDT, please don't hesitate to drop a comment below. I will be here to provide assistance and address your inquiries.

I'm doing the advance bank feed. After matching feeds to QB, what does it do? Does it copy of the transaction memo or something?

Question too. Some bank feeds have nested customers as well as refunds. I figured out that you can separate the customer with details section. For refunds, or cancel orders I can post it to QB from webgility, but it doesn't create a transaction where i can match the feeds if I'm short something 

It's great to have you back into this thread, nitsujayyy. I can help provide additional information when managing and matching entries in your banking feeds.

After matching transactions in your account, QuickBooks will match the downloaded entries with the ones you already entered in your file. This links them together, so you don't get duplicates and tells what transactions your financial institution has processed, and which haven't cleared the bank yet.

With this, all details entered from a specific transaction, this copies the information to QuickBooks once matched.

On the other hand, if there isn't an existing transaction created in QuickBooks to match the entry downloaded from Webgility, you can select Add or Add more details from the Action column. Please ensure to choose the associated account category first to match and link the entries, then will add them to your registers.

However, if you already had created an entry in QuickBooks and aren't able to see matches on the banking feeds, select Match to existing transactions option under the Action column. Doing so will add the entry to your banking registers.

Once everything looks good in the future, you can start reconciling your accounts to ensure they match your bank & credit card statements.

I'm all ears to any additional queries you may have when managing online transactions in your account. Feel free to leave them in the comments below. Take care and have a good one!

These are the only import options available for webgility. Which makes sense?

Hi there, @nitsujayyy.

I'm happy to assist with your question about the best import options.

When it comes to integrating accounting or e-commerce software, the most suitable import option depends on the specific needs and requirements of your business.

It's important to carefully assess your business's payment processing landscape and determine which import options within Webgility would best meet your needs for comprehensive data capture and reporting. There is no one-size-fits-all solution, as the optimal choice depends on your organization's unique requirements.

Additionally, you can refer to this resource to learn how to track customer transactions in QuickBooks Desktop: Get started with customer transaction workflows in QuickBooks Desktop.

If you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBDT Self-help.

I'm here if you have other concerns about importing or questions about managing transactions in QBDT. Feel free to drop a comment below,.

So I think I was able to get a years revenue and cogs. How can i properly do a reconciliation to make sure I didn’t miss anything. 

for example Webgility inputs order including fees and discounts, returns. Shopify payouts is like a payout of weather mixed customer or single, single being easier to match. 

Also let’s say I have a concern of an order and that’s because it had a confusing return/refund scheme, how can I see that transaction and basically confirm it’s what I got paid. Work with me I have ocd, please help me before I delete everything out and start again lol 

Hello there, nitsujayyy. I'm here to share my insights regarding reconciliation and how to view the details of your transactions.

When using QuickBooks Desktop (QBDT) to reconcile transactions, it's important to have a bank statement on hand to ensure that the correct accounts or entries are reconciled properly. You can also contact your accountant for more accurate results in the reconciliation process.

On the otherhand, to locate refunded transactions, you can navigate to the Transactions section within QuickBooks Desktop. From there, you can double-click on specific entries to view comprehensive details about the refunded transactions.

Here's how:

1. Go to the Customers menu, then choose Customers Center.
2. Click the Transactions tab, then select the Refunds section.
3. Find certain transctaction or you can also filter them out by clicking the Filter By and Date dropdown.
4. Once you find the transaction that you need to review, double-click the transaction.
5. A new window will pop up, then it will display the details that you wish to review.

You can also visit this website since it will help you when reconciling an account if you have several months or years of transactions in QuickBooks Desktop that have not been reconciled with your financial statements: Reconcile an account for multiple months or years of transactions and financial statements.

Furthermore, you can use this article if your accounts in QuickBooks Desktop don't match your bank statements at the end of reconciliation: Fix issues when you're reconciling in QuickBooks Desktop.

We're always here to assist you with any reconciliation needs in QBDT. Please let us know, and we'll gladly help you in any way we can.

the thing is when i import from webgility, those are the option. Then I check bank and reconcile it. At the same time, for some reason I cant apply the credit to the or refund to the order so that when im matching transaction, it matches or updates the balance

Let me chime into this thread and help you with your concern so that you can match transactions and balances seamlessly, @nitsujayyy.

We'll have to create a credit memo and check to successfully apply credit and refund to your customer's order. You can follow the steps I'll provide below.

Let's create a credit memo first so we can refund the money or credit your customer.

1. Open QBDT.
2. Go to Customers then Create Credit Memos/Refunds.
3. Select your customer from the Customer:Job drop-down.
4. Fill in the necessary information, then click Save & Close.
5. In the Available Credit window, choose Retain as an available credit. Selecting this option will result in a negative amount entered in your Accounts Receivable (A/R) register for the credit memo.

Once done, let's go ahead and write a check. To do so, here's how:

1. Head to Banking.
2. Click Write Check.
3. Add the necessary details.
4. In the Expense tab, please select an account that affects the Accounts Receivable.
5. Click Save & Close.

After creating this, we can now link these two in the Receive Payment section. This step is necessary for you to match these to your transactions. Please follow the steps below.

1. Go to Customers then Receive Payments.
2. Select your customer in the Received from drop-down,
3. Choose the Discounts and Credits icon located in the upper menu box.
4. Tick the credit you want to apply in the Credits tab and then Done.
5. You may encounter a prompt to confirm the transfer. If you do, please select Yes. The amount will be automatically applied to the invoice.
6. Hit Save & Close.

Please read this article for reference: Give your customer a credit or refund in QuickBooks Desktop for Windows.

After that, you can now match these with your bank transactions.

At the same time, you can refer to this article to learn more about voiding a customer payment that hasn't been settled: Void or refund customer payments in QuickBooks Desktop.

Don't hesitate to get back to this post if you need further help in applying for credits in your QuickBooks Desktop. I'll be sure to get back to you as soon as possible.