Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

How do I do this? thanks.
Solved
Best answer February 27, 2020

Best Answers
QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

You did a fantastic job, @sharonmcnulty.

 

The account history and view account register is the same.

 

Users using the International version of QuickBooks like UK, Singapore, South Africa, and the rest of the regions will see the account history while you'll see the view register when you're using the US account.

 

If you're using the International version and posted a query to a US region, you'll get US-based answers. The steps are the same from other regions while we're using different terminologies.
 

Since you've mentioned that the view register/account history button is missing, I suggest signing-out and signing in back to your account.

 

If the issue persists, I recommend using an incognito/private browser. Private browsing mode prevents using internet files from making QuickBooks' functions missing.

 

Open a supported browser and use the hotkey for the specific browser:

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

 

If this fixes the issue, clear your regular browser's cache. It helps load new cache data that can help boost the browser's performance.

 

Otherwise, open QBO to another supported browser.

 

To review bank and credit card transactions after you download them into QuickBooks Online, you can refer to this video article: Match and categorize bank transactions in QuickBooks Online.

 

Please let me know what QuickBooks version you are currently using so that I can help you provide the QuickBooks support page region.

 

Please leave a reply to this thread if you have further questions. I'm happy to help. Have a good one!

View solution in original post

15 Comments
QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hi @sharonmcnulty,

 

When you've already started using a bank account without entering an opening balance amount, it's still possible to enter it later on. 

 

You can proceed with posting a customer payment, and when you're ready, create a journal entry to record the opening balance. 

 

Here's how:

 

  1. Click the + New menu.
  2. Select Journal entry.
  3. Enter a date. Ensure that it comes before the oldest transaction in the account.
  4. On the first line, select the account you want to enter the opening balance for. You can view your bank statements to make sure the opening balance amount is accurate. 
  5. On the second line, select Opening Balance Equity under the Account column.
  6. Press Save when done.

 

If you have other questions with this process, it's explained in full in this article: What to do if you didn't enter an opening balance in QuickBooks Online. You'll see the whole process is divided into 3 sets of steps, as well as screenshots for your reference.

 

Feel free to post a reply below, in case you have other questions. I'll get back to you as soon as I can. 

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Sorry my query actually is, how do I post the payments (Supplier & customer) as I cannot allocate them due to opening balances not being transferred yet?

Moderator

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hello again, @sharonmcnulty. Thanks for your prompt response. 

 

As mentioned by my colleague @Ryan_M, you can create a Journal entry to record the opening balance. But before doing so, I recommend consulting with your accountant so they can guide you on what's the best thing to do. 

 

Additionally, I want you to get the most out of QuickBooks for your business. You can check some articles that are designed to help you get acclimated with the software. They can be accessed at the following link: QuickBooks Tutorials.

 

If there's anything else I can do for you, let me know by commenting below. I'd be happy to further assist you. Have a great day.

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hi @MirriamM & @Ryan_M  apologies I am obviously not being clear with my query.

My query is not about recording the opening balances. I cannot do this until our audit is complete next month.

My query relates to how to record payments to suppliers & from customers? At the moment many of the payments going through my bank account relate to invoices from 2019  that are currently not in Quick books so I want to know how to post payments on account?

I have manually imported my bank transactions and now need to record them in the relevant supplier & customer accounts. Most will be "on account" as I cannot allocate them against the relevant invoices until I post the opening balances after our audit.

Level 15

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

@sharonmcnulty 

You may have 4 different transaction types to be imported:

1. Bills

2. Bill-Payments

3. Invoices

4. Receive-Payments

 

Prepare your data transactions in XLS/CSV and utilize the 3rd party tool to import those data

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

@Fiat Lux - ASIA I am so confused! I have imported my transactions already. 

My only query is how to record the payments made & received (which I already have in my bank account on Quick Books) on the Supplier & Customer accounts? Many of these payments need to be payments on account as I cannot allocate them yest due to my opening balances not confirmed by our auditors.

 

Thanks.

QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hi there, sharonmcnulty,

 

I'm here to help post payments from customers and to suppliers in QuickBooks Online (QBO).

 

You can add those payments to the desired bank account in QBO. They become customer deposits and supplier expenses in the register.

 

I'm glad to guide you through the steps:

  1. On the For Review tab, add a payee (customer or supplier) and category to each payment.
  2. Once done, click Add.
  3. Select Go to Register to check those entries in the Chart of Accounts.
  4. You'll see them as expense and deposit in your register.

Once invoices are entered in QuickBooks, you'll link them with deposits, as well as bills with expenses.

 

Should you need anything else, feel free to leave a comment below. I'm always around to help you out.

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hi @MaryLandT Many thanks for your help. I am now in the review tab for a customer deposit.  Can I split the category for a deposit as it relates to two different income types?

 

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

@MaryLandT Also I do not have the option: Go to register, only go to account history?

QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Thank you for the quick reply, @sharonmcnulty.

 

Yes, you can split the category with different accounts, also the amounts. Let me guide you how:

 

  1. Go to the Accounting menu located on the left side.
  2. Select Chart of Accounts.
  3. Click the View register perpendicular to the bank.
  4. Double click the transactions. 
  5. In the Add funds to this deposit, choose the account in the Account drop-down arrow.
  6. Hit Save and close.

COA.PNG

save.PNG

For the detailed guide about the process, check out this article: Enter a split transaction into the register.


Let me know if you have follow-up questions. I'm always here to help. 

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

Hi @Michelle_b thanks for your response. That works. The only problem I have is when I go to chart of accounts, I don't have a view register button. Maybe I am missing something in my set-up as I cannot see it?

QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

You did a fantastic job, @sharonmcnulty.

 

The account history and view account register is the same.

 

Users using the International version of QuickBooks like UK, Singapore, South Africa, and the rest of the regions will see the account history while you'll see the view register when you're using the US account.

 

If you're using the International version and posted a query to a US region, you'll get US-based answers. The steps are the same from other regions while we're using different terminologies.
 

Since you've mentioned that the view register/account history button is missing, I suggest signing-out and signing in back to your account.

 

If the issue persists, I recommend using an incognito/private browser. Private browsing mode prevents using internet files from making QuickBooks' functions missing.

 

Open a supported browser and use the hotkey for the specific browser:

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

 

If this fixes the issue, clear your regular browser's cache. It helps load new cache data that can help boost the browser's performance.

 

Otherwise, open QBO to another supported browser.

 

To review bank and credit card transactions after you download them into QuickBooks Online, you can refer to this video article: Match and categorize bank transactions in QuickBooks Online.

 

Please let me know what QuickBooks version you are currently using so that I can help you provide the QuickBooks support page region.

 

Please leave a reply to this thread if you have further questions. I'm happy to help. Have a good one!

View solution in original post

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

@Jovychris_A  Thank you so much, I am learning everyday! Yes I am in Europe so that makes sense. I will know for the future. Thanks again for your help.

QuickBooks Team

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

You're always welcome and I appreciate your willingness, @sharonmcnulty.

 

It's great to see that you're learning our product every day.
 

To provide you the right steps and prevent confusion in the future, you can click the flag on the upper right. Then choose the flag or the region you wanted an answer with your query.


If you were unable to see your flag in the options, select the Global flag that answers the rest of the world queries.

You can always leave a message or leave a post to your region if you need further assistance. I'll be around to help. Enjoy your day!

Level 3

I have started using Quick books this year. I have imported bank transactions and want to post a customer payment on account as opening balances are not transferred yet.

@Jovychris_A  thanks this is also really helpful.  I am in the US version even though I am based in Ireland. When I post my question when I am logged into Quick books I can only change the flag after I post my question.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us