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. 

Hi, 

I am new to QB and am trying to upload my past bank transactions from a CSV file. This appears to be in the correct format (3 columns in the correct order etc) however there is an error when trying to do this in QB. 

Any suggestions?

Sean

• Special characters are not allowed.
• Zeros (0) are not allowed anywhere in the file.
• Correct any transactions that display an amount in the Description column.
• Remove the word amount if it appears in the name of the Credit or Debit column.
• MAC users must save the file as a Windows CSV file.
• Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
• Some banks provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE in column A) which is not an acceptable format. To correct this, split the date and the day of the week in two separate columns.
  
  

• Safari: Command + Shift + N
• Mozilla Firefox: CTRL + Shift + P
• Google Chrome: CTRL + Shift + N
• Microsoft Edge: CTRL + Shift + N
  
  

I have recently purchased a new laptop for my business on HP. How do I record the monthly payments on QBSE?

Thanks Jamie 

Thanks for joining us here, Hamilton.

I'm here to ensure you can record monthly payments in your QuickBooks Self-Employed (QBSE) account.

To begin, if your account isn't connected yet to QuickBooks, you can manually add transactions to record the payments in your account. 

Here's how:

1. On the left navigational panel, go to the Transaction menu.
2. Select Add Transaction.
3. Enter the amount and a description.
4. Choose the Select category menu to organise your transaction. To learn more about categories, check this out. 
5. If you have a receipt, you can drag and drop it onto the form.
6. Once done, hit Save.

However, if your account is already connected, QuickBooks will automatically download the transactions, and all you have to do is to categorise them. 

Additionally, here's an article you can browse in case you need assistance creating a new transaction from a receipt image: Record or attach expense receipts in QuickBooks Self-Employed. 

Keep me posted in this thread if there's anything else you need further assistance with when recording payments. Stay safe, and have a good one.

I am using QB Online and am struggling with one solitary transaction on the bank feed. The amount on the feed is eg £20 but when I try to match it to the corresponding Customer payment a message pops up : 'Partially matched £40 remaining out of £20'.  This makes no sense on a couple of levels! The amount on the feed corresponds to the actual paper bank statement which corrresponds to my records.

Every other transaction on the bank feed has matched the amounts.

I am at a loss as to what has happened and therefore, what to do about it. I have refreshed the feed, deleted and re-posted the Sales Receipt, logged out and logged back in again. 

Any suggestions?

Hi S Brockbank, thanks for joining this thread 

We'd like to make sure you're able to match your bank transaction to the sales receipt in QuickBooks. 

To check for any cache issues that may be causing the message to appear, please try logging into QuickBooks through a different browser or incognito window. 

If this doesn't fix, I'd recommend contacting our team by live messaging or on 0808 234 5337. The agents available here will have access to set up a remote screen share with you in order to take a close look. 

Hello,

I am trying to upload some bank statements as csv files. The formatting is all correct, all the fields are full and the file size is way below the 350KB max. Although all of the dates are there on the csv file when I import it big chunks of date information disappears. 

Any ideas how to stop that happening? 

Thanks for joining this thread regarding the issue with uploading your bank statements as a CSV file, Hannah. I’m here to help you out!

To assist you better, please let me know if you've encountered any error messages when uploading the CSV file. This will help us narrow down the issue.

I appreciate your diligence in ensuring the correct format is applied. However, one of the possible reasons why the date is not showing on the file is that the maximum upload limit of 1,000 rows (including the header) is exceeded. 

Given your issue with missing date information, I recommend checking the following:

1. Date Format: Ensure that the dates in your CSV file are in a format that QuickBooks supports, such as MM/DD/YYYY (if your region supports that) or DD/MM/YYYY. Formatting the dates as plain text in Excel may cause issues, so you might want to select the entire date column and format it as a “Date” in Excel.
2. Review for Empty Rows/Cells: Check your CSV file for any blank rows or empty cells in the date column, as these can impact the upload process.
   • Private Browser Upload: Please try opening your account in a private browser to upload your transactions. Here are some examples of the keyboard shortcut keys: Mozilla Firefox: CTRL + Shift + P
   • Microsoft Edge: CTRL + Shift + N
   • Google Chrome: CTRL + Shift + N
   • Safari: Command + Shift + N

If the date information successfully applies after this and is no longer disappearing, it was browser-related. In that case, clearing your regular browser cache will help, or consider trying different supported browsers.

For further information on formatting requirements, refer to this article: Format CSV files in Excel to get bank transactions into QuickBooks Online.

Lastly, here’s a helpful article in case you uploaded the data to the wrong bank account: Exclude a bank transaction you downloaded into QuickBooks Online.

Please return to this thread if you need further assistance with your bank statement uploads. I’ll be around in the Community and happy to loop back again to help you. Take care.

The only message which comes up says .. 

Some info may be missing from your file. Double-check that your file is complete and try uploading again.Start over

There isn’t any info missing though. 

The file is less than 100 rows, I’ve tried safari and chrome in regular and private windows now but no luck. 

A red ! Symbol in a circle comes up in the date column one the sections where the date is missing. 

Thanks for providing further details, Hannah. Here's the information you need to import your bank transactions.

Since you've verified your format is correct, the next thing you'll have to ensure is the accuracy of your mapping. The red exclamation (!) symbol in a circle indicates that a date is needed for the section that's missing this information.

Once the required data is entered, start re-uploading your CSV file. Please see the For customers using QuickBooks Online drop-down section for the step-by-step guide: Manually upload transactions into QuickBooks.

Otherwise, I recommend contacting our Support team to report if the issue continues. Here's how:

1. Sign in to your QBO company.
2. Go to the Help (?) menu.
3. Select the Search tab and click the Contact Us button.
4. Briefly describe your concern in the What can we help you with? field.
5. Click Continue.
6. Choose a way to connect (Callback or Chat ).

Moreover, I encourage you to reconcile your accounts regularly (monthly). Doing so will let you track your finances and manage them accordingly.

Please don't hesitate to comment below if you have other banking concerns or inquiries about managing your transactions in QuickBooks. I'll be sure to get back to you. Take care always.