cancel
Showing results for 
Search instead for 
Did you mean: 
Super Explorer *

Loading of bank transactions manually into Quickbooks online

Can  someone please assist me.  I am pretty new in accounts and desperately need help. I have entered my banking transactions manually, using the BANK DEPOSIT option, as I have had an issue importing the bank statement into QuickBooks online. My banking statement shows the funds received as a CR and the expenses as a DR, so I need to ensure QuickBooks balance to the bank statement, but  once I have finished entering each transaction into QuickBooks, the funds received and the expenses both reflect as credits in QuickBooks. Example:  R-351,174    INCOME R-376,007 EXPENSES   I do enter each transaction as a debit when entering the expenses in QuickBooks. The amounts balance to the bank statement, except my funds used (expenses) reflect as a CR and not a DR.  Where have I gone wrong?

 

I have also tried to enter the opening balance amount as a credit using the Opening Balance Equity Account, but it will not accept it as a credit amount. What am I doing wrong, please can you assist me? 

Thank you kindly

Solved
Best answer 09-06-2018

Accepted Solutions
Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hello

 

Using the journal entry, can I enter the credit amount using the Opening Balance Equity in the account field ?

 

Regards

Margie

18 REPLIES 18
QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

Hi Mags1,

 

Thank you for contacting the Community.


Can you please provide a screenshot of both a deposit and journal entry you have created so I can look into this for you.

 

Thanks, Carly. :)

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hi Carly,

Thank you so much for the reply.  I have attached a screenshot of some transactions I have loaded.  As you can see I have captured the expenses as debits and the funds received as credits.  For easy reference, I have attached the dashboard reflecting the income vs expenses and a snapshot of the bank statement summary.

As mentioned surely my dashboard reflecting the income vs expenses (both showing CR), should be the same as my bank statement summary, Income CR and Expenses DR.

So appreciate you helping.

Regards

Margie

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hi Carly

I see I could only attach one document at a time. Previous attachment, snapshot of the bank statement. I will attach the screenshot of my manually entered bank transactions. Thank you

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hi Carly,

Last attachment - snapshot of Dashboard showing Income vs Expenses

QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

Hi Mags1,

 

Thank you for providing the screenshots.

 

Rather creating a bank deposit I would recommend to create expenses for the money out and sales receipts for money in. To do this click the '+' button in the top right hand corner and click either expense or sales receipt.

 

Thanks, Carly.

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Awesome, thanks Carly.

Would I need to go and delete all my transactions already loaded and load them as per your suggestion?

Also would this change the funds used (expenses) to a DR and not reflect as a CR on the dashboard screen? Or does this not matter?

Regards

Margie

QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

Hi Mags1.

 

If you have already created the transactions as bank deposits you would need to delete these and then recreate them as sales receipts, this would just make sure the transactions aren't being duplicated.

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hi Ash,

 

Thank you for your reply.  So, I would delete all the "sales" (funds received) transactions I entered (credit card payments to us) as bank deposits and re-enter in the "sales receipts" menu?

How would I go about loading the funds used "expenses" transactions that I also loaded as bank deposits?

Thanks

Margie

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Sorry Ash, Carly mentioned I should enter the funds used"expenses" in the expense menu.

Highlighted
QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

So any of the money you receive into the business would be recorded as Sales Receipts and any of the Expenses out of the account would be recorded as Expenses transactions :)

 

 

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Super, thank you.  You and Carly have been a great help!

Just another question:

Where do I enter the opening balance amount, that I have on my bank statement as a credit using the Opening Balance Equity Account in Quickbooks?

Thank you

Margie

 

QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

Hi Mags1,

 

I'll let @AshH + @CarlyL know you think they've been fab!

See this guide: https://community.intuit.com/articles/1145780-how-do-i-enter-a-beginning-balance-for-an-account-afte...  - Normally, we'd direct you to go to your accountant, and I'm still going to recommend you do this

 

However, In a nutshell; you use a Journal Entry, setting the date as the beginning of the statement date; and using the credit/debit columns you'd either move money to or from the account, with the other side of the journal being Open Balance, to give you a positive or negative balance in the account.

 

Thanks,

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Thank you for your help.

Regards

Margie

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hello

 

Using the journal entry, can I enter the credit amount using the Opening Balance Equity in the account field ?

 

Regards

Margie

QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

You would be able to yes :)

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Thank you

Margie

Super Explorer *

Re: Loading of bank transactions manually into Quickbooks online

Hi Ash

 

Apologies for quering this again, as mentioned earier, I will use the journal entry and enter a credit amount using the Opening Balance Equity in the account field?

However, what account would I use to enter the debit amount and what customer name would I use?

The amount I am entering for the Opening Balance Equity is the credit amount I have in the bank (when I receive the bank statements).

Hoping you can assist me again

Thank you

Margie

 

QuickBooks Team

Re: Loading of bank transactions manually into Quickbooks online

Hi Mags1,

 

Thank you for getting back in touch.

 

You would use the Opening Balance Equity on one line of the journal and the account you are wishing to credit/debit in the other. in this case your bank account.

 

You will not need to enter a customer name as you are not using the Debtors account.

 

Please let me know if there is anything else I can help with. :)