Financial - How to upload payments
  • 14 Dec 2023
  • 1 Minute to read

Financial - How to upload payments


Article summary

This article is a walk through of how to import payments to family financial ledgers.


Import Payment/Adjustment Process

  1. Click Reports, then select Financial
    Image

  2. Click Actions, then select Import Payment/Adjustment Spreadsheet
    Image

  3. Click in the Upload a Spreadsheet section to select the file from the computer
    Image

  4. In the Payment Import section, select Version 5 (ImportPaymentV5.xls)
    Image

  5. Click Import to add payments to family ledgers


Import Details

Sheet Layout:

Payment DateFamily IDPayer NameBatch NumberPayment NotesPayment Type (Valid Value Description)Check NumberAmount
3/28/2019434898Export Test1Test NotePayroll Deduction12345500

Field details (example):

  • Payment Date - enter today’s date
  • Family ID - enter the Family ID from the system
  • Payer Name - enter the parent’s Name
  • Batch Number - enter the user defined batch number
  • Payment Notes - enter any payment detail
  • Payment Type - type the name of the payment type
  • Check Number - enter the check number, if applicable
  • Amount - enter the total that should be added to the family ledger

Was this article helpful?