Ok, thanks.

Hello, feprimafi.

We in the Community are extremely happy that you were able to find my colleague's post helpful and able to resolve your issue. We're more than happy to help you if you need more assistance.

If you need tips and resources to manage your QuickBooks Online account and finances, feel free to visit our Support page to learn more. This provides information to help your navigation experience be more effective.

Keep us posted if you have other questions or concerns. I’m here to help you out. Take care and have a great day!

We use Clio online and sync directly into QB online.

Some client invoices are paid and the bank deducts a fee at source therefore the amount applied in Clio is $15 greater than the amount uploaded in QB as part of the bank reconciliation process. 

If payments received at less than $500 in total these do show up as an option to match in the banking transactions tab but are imported as an undeposited fund and will show up when matching other transactions on the same date for a greater $ amount.

How can I match these off correctly.

I'd gladly help you match your clients' payments with the bank transactions, @Jdontas.

To do this, you can create an expense account for bank fees and then resolve the difference by matching the transaction from your bank feed. Here's how:

1. Go to Transactions and select Chart of accounts.
2. Click the New button.
3. In the Account pop-up, choose Expenses from the Account Type dropdown.
4. Select Bank charges from the Detail Type dropdown.
5. Enter Name as Bank fees.
6. Click Save and Close.

Your account is now created. To resolve the difference, you can refer to the steps outlined in this article's "Resolve the difference" section: How to account for bank fees when matching transactions in the bank feed. Although the article is for AU users, the steps are the same for UK users.

In case you want to categorise your transactions automatically, you can check out this article for more guidance: Set up bank rules in QuickBooks Online.

Should you have any other concerns besides matching your clients' payments and bank transactions, please leave a reply. The Community is always eager to help.

Hi

I have uploaded bills to add to a supplier account but one of the fields is “bank/credit” .. it won’t allow me to choose creditors and won’t let me post the bill without completing this field  what should I be using here? 

Let me share some details on why you encounter an error message when using a creditor's account on the uploaded bill, Karen545.

When recording the receipt as a bill, the bill transaction can't be categorized as Account Payable (AP) since the transaction itself is posted in the AP account. This is the reason why you encounter an error message "You can't use a Creditors account on the detail portion of a Bill". See the screenshot for your reference:

To resolve this, we'll need to record the expenses for a specific expense category since you'll have to create a bill. Here's how:

1. Go to the uploaded receipt.
2. Click the Edit receipt details link.
3. In the Account/Category field, select an expense account.
4. Tap Save and next. 

You can check out this article for more details about uploading your receipts and bills from suppliers: Upload your receipts and bills to QuickBooks Online. Once done, you can pay the bills by using the Pay Bills option to pay open bills from different suppliers at once. There are checkmark boxes beside the transactions to make the task easier for you. Here's how:

1. Click the + New option in the upper-left corner.
2. Tap Pay bills under Vendors.
3. Put a checkmark on the bills you want to pay from multiple suppliers.
4. Press Save and close.

For more information about managing bills in QBO, you can check out this article: Enter bills and record bill payments in QuickBooks Online. Feel free to refer to these articles for future reference on handling receipts:

• Create and send sales receipts in QuickBooks Online
• Email receipts and bills to QuickBooks Online
• Customise invoices, estimates, and sales receipts in QuickBooks Online

If you ever come across any more concerns or ideas regarding uploading your receipts and bills from suppliers, you're always welcome to reach out. I'm here to help you and address any questions you may have.

I need to import transactions older than the limit that exists in Quickbooks. I have a CSV of all transactions from my business bank account.

• I have manipulated it into the four column format of; date, description, credit, debit.
• I have removed all amounts that equal zero in the credit and debit columns.
• The date format is all dd/mm/yyyy. 
• I have removed the symbols *,-/ from the description column
• I have deleted all blank rows under the data just in case of any hidden characters.

This CSV document absolutely refuses to be imported. I can't think of anything else that would need to be fixed. 

I appreciate you for sharing a detailed explanation of your concern, steck. I acknowledge the importance of having a seamless importing process, and I'm here to ensure you can successfully do it. 

When importing bank transactions in QuickBooks, you may encounter specific errors. If you encounter such, you can refer to the last section in this article as a guide in fixing it: Fix bank errors. 

If you haven't encountered any error messages and have already corrected the mapping and columns, we can perform some troubleshooting steps to rectify this. 

Here are some keyboard shortcuts you can use to switch to a private browsing window:

• Google Chrome and Microsoft Edge: Ctrl+ Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Safari: Command + Option + P

Once you successfully imported your CSV file, return to your regular browser and clear your cache. Accumulated cache and cookies in the system can become outdated or corrupted, leading to unexpected issues. You can also switch to other installed supported browsers, which is a good alternative.

If the issue continues, I recommend contacting our technical support. Our team of experts can arrange a screen-sharing session and ensure you can successfully import your CSV file. 

To reach them, you can follow these steps:

1. Hover over to the Help menu and click the Search tab.
2. Select Contact Us and type in a short description in the box provided.
3. Choose Continue, then pick the Chat or Callback option.

I'd also like to provide some resources that can help you manage your transactions more efficiently:

• Categorise and match bank transactions. 
• Set up bank rules to categorise online banking transactions.
• Create recurring transactions.

If you need further assistance with importing your transactions or any other QuickBooks-related concerns, please feel free to use the reply button below to raise your concerns. I'm always here for you, steck.