The Book-keepers Forum (BKF)

Post Info TOPIC: How to enter bank statements in QB?


Newbie

Status: Offline
Posts: 2
Date:
How to enter bank statements in QB?
Permalink Closed


Hello,

 

I'm new to QB, I love it so far, but just wondering how I can enter the bank statement transcations or upload them if the bank institution is not listed in the downloads bit?

 

I'm using Premier Accountant Edition

 

Thanks in advance



__________________


Senior Member

Status: Offline
Posts: 188
Date:
Permalink Closed

Depending on if you are using the online or desk top system you will need either an .ofx or .csv file from the bank then just follow the steps given to upload into QB

__________________


Newbie

Status: Offline
Posts: 4
Date:
Permalink Closed

You should always enter the bank accounts at the last. This is because the accounts payable and accounts receivable accounts may vary and affect the QB accounts. Bills and invoices should be entered first.

__________________


Member

Status: Offline
Posts: 11
Date:
Permalink Closed

As QB is so easy, I don't bother trying to upload the bank statements; it's just as quick to manually enter the transactions. Then, if you come across A/P or A/R transacions, it doesn't foul things up. IMHO anyway :)

__________________

David P Anderson FAIA

 



Veteran Member

Status: Offline
Posts: 26
Date:
Permalink Closed

I've used quickbooks for years, and I've found if you can't upload it, there are 2 good ways to enter bank statement transactions:

1.

Individually - input them as a "write cheque" that way to can keep track of who they're for and easily input tax codes etc and they'll show up in all the right places elsewhere. This also means you can use different dates for the transactions.

 

2.

As a batch, enter them as a general journal entry, crediting or debiting one line to the bank account and the other to the relevant income/expense account. This is useful for companies that receive lots of credit card income for example. Just make sure you keep each transaction separate to avoid confusion, and ALWAYS enter a good description so you know exactly what it is if you need to go back to it - it's also a good idea to note the journal number next to each transaction. As a batch you would only want to set it as one date - for example if you reconcile monthly and you're reconciling June for example you would date the journal as 30/06/14 so it shows up in the right month.

 

Hope that helps!

Anymore questions respond on here or ask me directly at http://howtobookkeep.com/ask-me/



__________________

Howtobookkeep.com is your one-stop-shop to find out how to bookkeep. Check out our blog or ask us for more info!



Senior Member

Status: Offline
Posts: 476
Date:
Permalink Closed

I don't upload them either. I'm a control freak and like to know exactly what is going in.

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About