PsalmlyHelp center

Psalmly home
GivingAdmins

Import past giving from another system

Bring the gifts your church recorded in Tithe.ly, Breeze, Planning Center, Pushpay, QuickBooks or a spreadsheet into Psalmly, so year-end statements, Giving by person and Finances are complete from day one — and undo the whole import if anything looks wrong.

Moving to Psalmly from another giving system? Bring last year's gifts with you, so January's statements, Giving by person and Finances show the whole year, not just the months since you switched. You export your gifts from your old system once, drop the file into Psalmly, check what it found, and press Import. If anything looks wrong afterwards, you can undo the whole import in one step.

Importing gifts is part of the church's books, which come with Community and Growth. Like the Giving page, it's limited to lead admins and admins a lead has given finance access. Open Giving and choose Import past giving at the top.

What comes in

Each gift's date, amount, giver and fund, plus the payment method and check number when your file has them. Nothing else: people, pledges and recurring schedules stay in your old system. (People come in through Directory → Invite people → Import a file, and pledges through Record pledges.)

An imported gift is a recorded gift, like a check entered with Record offering. It sends no receipt, and it shows up everywhere a recorded gift does: the gift list, Giving by person, each person's statement and Finances. Cash and checks keep their method; card and bank gifts come in as Other.

The amount is what the giver gave. If your file has a net amount and fees instead of one amount, Psalmly adds them together, because a statement shows what the giver gave, not what reached your bank.

Getting the file out of your old system

Export your gifts as a CSV or Excel file. Up to 20,000 gifts fit in one file; for more, export one year at a time and import each file.

  • Tithe.ly — in Giving, open Transactions, set the date range with Filter, then Export. The file has the columns showing on that screen, so show the name, email, fund, amount and status columns first. See Tithe.ly's article How to Export Transactions.
  • Breeze — Account Settings → Manage Account → Export, then choose Contributions. If the export times out, Breeze suggests exporting one year at a time from Giving.
  • Planning Center — in Giving, export your donations from the Donations list.
  • Pushpay — export your transactions, keeping only the successful ones.
  • QuickBooks — run a report of your donations by customer with the date, customer, amount and account columns, and export it to Excel.
  • A spreadsheet — choose Download a template on the import page and fill it in: Date, Amount, Name, Email, Fund, Method and Check number.

Dates are read month first, the US way: 3/4/2025 is March 4.

Checking the columns

Every file goes through one short step: Psalmly shows each thing it needs (date, amount, name, email, fund and so on) next to the column of your file it picked, with the first few values, so you can see it picked right. Change any of them, or choose Not in this file. The date and the amount are the only ones you need; a gift with no name or email comes in as loose plate cash.

Also tell Psalmly where the file is from. That only names the import in your list and on each gift; it doesn't change how the file is read.

Checking what's in the file

Before anything is saved, the next screen shows:

  • What's in the file: how many gifts, from how many givers, the dates they cover and the total — with a total for each year, so you can compare it with your old system. Below it, Left out lists every row that won't be imported and why; Download the rows left out gives you them as a file.
  • Givers: where each giver's gifts will go. Psalmly matches a giver to someone in your Directory by email first, then by a name exactly one person in your Directory has. Two people with the same name are marked Needs a look so you can pick the right one.
  • Funds: each fund in your file and the Psalmly fund its gifts go to. Funds with the same name match, general giving ("General", "Tithe", "Offering") goes to Tithes & offerings, and anything else is created. New funds are hidden from your give page; you can show one from Funds.

Givers who aren't in your Directory

Psalmly asks one question about them:

  • Keep the name from the file (the default) — their gifts are recorded under the name in the file. You can match them to people later from Giving by person, or pick people one by one in the list.
  • Add them to your Directory — each becomes a person on your roster, so they get a statement in January. Being in your Directory has two effects, and the screen says both: people with an email get your church-wide announcements and the bulletin by email, and everyone in your Directory counts toward your plan's limit.

Keeping the name is the safer choice for an old file: you know which givers are still part of your church. To give one of them a statement later, open Giving by person, find their name, and use Match these gifts to… → Add a new person.

What's left out, and why

Psalmly never counts a gift twice:

  • Already imported — the same gift came in with an earlier import. Importing the same file twice adds nothing.
  • Looks like a gift already here — a gift in Psalmly has the same date, amount and giver. These are left out unless you choose Include these (two $50 checks on the same Sunday, say).
  • Refunded, failed or not completed (pending, waiting on the giver, or disputed) in the old system, when the file has a status column. A status Psalmly doesn't recognize comes in.
  • Refunded in part — when your file has a refunded-amount column, a gift comes in at what's left after the refund, and one refunded in full is left out. A gift marked partly refunded in a file that doesn't say how much is left out, so you can enter it yourself: Psalmly never guesses an amount.
  • A refund or $0 row — a negative amount is never subtracted from another gift; check the gift it refunds in your old system and edit it in Psalmly if you need to.
  • Rows with no date or no amount Psalmly can read, or dated in the future.

Gifts given to members

When an imported gift goes to a member of your church, it shows in that member's own giving history and on their statement in the app, the same way a check you record for them does.

Undoing an import

Your earlier imports are listed on the import page. Undo this import removes every gift that import added from your records, statements and reports, and archives the people it added that nothing else in Psalmly uses yet — a person who has since been given another gift, a pledge, a match, a link to a member or an edit stays. Funds it created stay. You can import the file again afterwards.

To fix just one gift, open it in the gift list and edit or delete it like any recorded gift.

Related:import givingimport past givinggiving historyimport donationsimport contributionsmove from tithelymove from breezemove from planning centermove from pushpayquickbooksspreadsheetcsvexcelswitching systemsyear-end statementsundo import