help with bank statement importing!

[shetalksinstere]

I have one bank that only uses the .csv format for their bankstatements and Peachtree does not allow that one. I downloaded a free converter and that has been fruitless.

Does anyone have any tried and true methods of doing this?

Thanks!
Michele

[Robert Walraven]

Read your .csv bank statement into MS Excel. Print it out. Set Peachtree to the accounting period for the month you want to reconcile. Run the Account Reconciliation form in Peachtree and select the account you want to reconcile. Enter your statement ending balance and check off all transactions that show on your bank statement.

[Debit]

We do what Robert says, but like Michele we want to be able to pull into Peachtree the bank's dump. It'll help to knock out matched transactions faster, and green flag those in question.

We are considering switching banks because of this issue.

[LauraG]

Have you looked at the PT instructions provided when your bank is not on their list of supported banks? See if that helps simplify the steps.

[Debit]

Man, December has been overwhelming to say the least. (we are a multi-store retailer). Anyways yes Laura I went thru all the steps etc., including trying to see if we dump our transaction into Microsoft Money, and then try to import back this file. Money export files are limiting and not on Peachtree's approved import file list. So, I too am stuck.

[LauraG]

While I found the bank downloads helpful in identifying missing transactions I also found that doing the bank recs took 2 or 3 times as long to complete because I had to manually create the missing transaction and then tell PT to match it with the downloaded entry.

I found it easier/faster to just print out the bank statement and manually verify that all transactions were posted before doing the bank rec. I dump the register detail to excel and go from there.