Topic Options
#35649 - 02/19/13 11:13 AM Bank Rec - Negative Values
erin p Offline
Adagio Buff

Registered: 03/30/08
Posts: 50
Loc: Goderich, Ontario
Going in today to import our bank statement into BankRec (first time since our recent update to 8.1D). The debits in the bank statement are showing up with a double negative (ex: --56.50) and throw an error when I import. Not sure what I need to do to change the setting so it does not add the extra character, please help! Our template from the bank did not change.

Top
#35651 - 02/19/13 12:27 PM Re: Bank Rec - Negative Values [Re: erin p]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Did the bank change their download file? Has it been downloaded in the same format as the import template was designed for? Does your bank offer a download formatted for Simply Accounting or QuickBooks, both of which export in OFX format.
_________________________
Andrew Bates

Top
#35657 - 02/20/13 05:55 AM Re: Bank Rec - Negative Values [Re: Retired_Guy]
erin p Offline
Adagio Buff

Registered: 03/30/08
Posts: 50
Loc: Goderich, Ontario
Everything looks exactly as it was before. I have sent the bank a message for confirmation, but the file does not appear to have changed. I tried the ofx version and it worked fine...still baffled by the csv though!

Top
#35658 - 02/20/13 06:12 AM Re: Bank Rec - Negative Values [Re: erin p]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Generally, we recommend using the OFX file if it's available. There's no ambiguity about the layout.

Did you run a process on the downloaded CSV before submitting it to be imported? It sounds like the bank decided to put a minus sign in the file and that something external added an additional one.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 107 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14418 Topics
70475 Posts

Max Online: 432 @ 01/20/25 10:17 PM
February
Su M Tu W Th F Sa
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28