Topic Options
#45331 - 04/14/15 02:10 PM Import to bank rec
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
(71.105.82.252)
Is there a blank excel emplate somewhere for importing journals into the Bank Rec module?

Thanks!

Top
#45334 - 04/14/15 05:35 PM Re: Import to bank rec [Re: ASANTOS]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3654
Loc: Toronto ON, Canada
(70.24.49.174)
There are sample files in the Bank Reconciliation sample data. The files are different for Payments and Deposits and must be imported separately.They are in comma separated format (CSV).

CSV file for Payments = \Softrak\BRWIN\SAMDATA\BRPAYIM.csv
CSV file for Deposits = \Softrak\BRWIN\SAMDATA\BRDEPIM.csv

The best approach is to first test in sample data so that you can see what the Import template must look like.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#45335 - 04/14/15 05:50 PM Re: Import to bank rec [Re: ASANTOS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(50.67.16.211)
You should also refer to the Import/Export Document on the Tech Tips page on our web site, and also the F1-Help on the Import Template definition dialog.

You can import Receipts, Payments and Bank Statements (for electronic reconciliation).
_________________________
Andrew Bates

Top
#45424 - 04/22/15 07:05 PM Re: Import to bank rec [Re: Bruce Gardner]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
(71.105.82.252)
Thanks! I'll start with these

Top
#45425 - 04/22/15 07:05 PM Re: Import to bank rec [Re: Retired_Guy]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
(71.105.82.252)
I'll be sure to check it out. Thanks!

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 377 Guests and 6 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14566 Topics
71089 Posts

Max Online: 1089 @ 11/18/25 11:03 PM
November
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 29
30