DonorWise TM
Enhanced communication with donors, enhanced ministry credibility...
Creating a new Transfer Batch (Import)

Contents

 


It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Syndication

Creating a new Transfer Batch (Import)

Print this Topic Previous pageReturn to chapter overviewNext page

The easiest way to maintain a list of account transfers for your staff (or any designation) is with an Excel file.

Creating a new Import Transfer batch

1.Prepare your Excel file.

Field Name (type exactly as shown for required fields)

Required?

Description

Payment Type Code

Yes

Must be TRANSFER

Donor ID

Yes

This is the designation that is giving the gift

Designation ID

Yes

This is the designation that is receiving the gift

Tendered Amount

Yes

This is the amount of the gift (in your base currency)

From

No

For your reference, as it makes it easier to identify the name of the donor

To

No

For your reference, as it makes it easier to identify the name of the designation

End Date

No

For your records. Sort each month by this field so that you know when to stop a transfer. For transfers with no end date, select a date far in the future.

Here is an example of what the Excel file would look like:

2.Save as a .csv file.

Importing the Transfer Batch

3.Select the <New Batches> screen.

4.Press the <Import Batch> button.

5.Enter a Description (such as “Import Transfers”—use the same name every month for consistency). Select the accounting period and date. This date will apply to all transfers in the batch. Press the <Next> button.

6.Press the <Browse> button. Select the .csv file. (Double-click or press the <Open> button.)

7.Press the <Next> button.

8.The Import donations screen will show all of the fields, with the four required fields already selected (if you typed them exactly). At the bottom of the screen is the data that will import. (Notice that the From, To, and End Date columns do not have headers; these columns will not import into the batch.)

9.Press the <Test> button to test for accuracy.

10.Press the <Import> button to complete the import. The rest of the steps are the same as a normal bank transfer batch.

Read More

Transfer Batches

Creating a new Transfer Batch (Manually)