Transfer balances to next School Year Invoice

As of July 12, 2021, this "Learn Veracross" site has been deprecated.  It will remain live through December 2022, but will no longer be updated. All knowledge content has moved to the new Veracross Community.  Please update your bookmarks.

Here is the new version of this article in the Veracross Community.

Overview

The process to move amounts from one invoice to another is a manual one.  This is because Veracross has the ability to show all invoices on the parent portal; calculates a total balance due of each invoice and presents that grand total to the parent.  However,  cases may arise where balances need to be moved to the next school year's invoice.  

Step by Step

Here is a an example query used to export Last Year (LY) Balances. We are using the example of transferring 19-20 balances to 20-21 invoices.  Any query can be used, this is simply  Veracross' example query of summarizing balances.

https://accounting.veracross.com/schoolshortname/#/results/49512

Step 1: Zero out 19-20 Invoices

1. Export LY Balances to Excel and formulate the data to match the PCI Import.  All columns need to be filled in but it's important to note the following: School Year should be 2019; Quantity = 1; Unit Price = inverse of amount in LY Export; Item_Amount = quantity x unit_price.

2. Import PCIs and post the inverse charges onto the 19-20 invoices to force the unpaid amount to go to zero.

Step 2: Add Credit or Balance onto 20-21 Invoices (this can be on the same import as above, if you don't want to do this twice)

1. Formulate the PCI Import, again everything should be filled in but it's important to note the following in this import: School Year should be 2020; Quantity = 1; Unit Price = LY Balance; Item_Amount = quantity x unity price.

2. Import PCIs and post the charges onto the 20-21 invoices to add the credit or balance.