The Book Bag : Reconciliation

Student Billing Reconciliation Redux

Charles Soderlund — Fri, 16 Oct 2009 16:43:00 GMT

Greetings faithful blog readers!

We recently held a customer round table regarding the fabulous topic of reconciling Student Billing to General Ledger. This was the first of many sessions we hope to hold discussing popular topics in Student Billing. Our support team is working hard to develop these sessions for all products, and to that end, I thought it would be a great idea to gather some feedback on what we developed for the Student Billing session I conducted. Below are links to our FAQ page with the Powerpoint slideshow and the recorded discussion with video screen capture directly from our live session. Check these out!

Student Billing FAQ and Reconciliation Roundtable

I will be adding more reconciliation tips and tricks to future blogs. Tell me what you think about what we have now for Student Billing and keep your ear to the ground on our forums to sign up for future sessions, they have been filling up quickly!

Cheers!

Charles

Live Support Seminar: Student Billing Reconciliaton Roundtable

Katie Infinger — Fri, 17 Jul 2009 11:57:00 GMT

On Tuesday, July 28 from 2:00 p.m. to 4:00 p.m. ET, we are having a Support Seminar and live Q&A session called "Student Billing Reconciliation Roundtable." Our Senior Product Support Lead, Charles Soderlund, will give an overview of the reconciliation process, including advance deposits and applications, reports, transaction control business rules, and troubleshooting tips and tricks. After each section, there will be time for your questions and ideas!

If you are interesed in attending, cast your vote!

Student Billing State-of-Mind: Reconciliation Recommendation

Jennifer Maroney — Fri, 15 Aug 2008 12:58:00 GMT

I wanted to share a great reconciliation tip with you guys. In Student Billing 7, all credits and payments need to be applied to charges to ensure statements are correct. So the question is how can you tell if there's activity that needs to be applied? The first thing you need to do is create a record query for records with a balance greater than zero. Here's how:

Create a new record query.
On the Criteria tab, select Activity, Summary, Record Balance, Operator greater than, enter a value of 0 and click OK.
Save the query.

We can now use the query to filter the Unapplied Credit report to show the records with a balance and unapplied payments or credits.

In Reports, Transaction Reports, highlight Unapplied Credit Report, and click New.
On the General tab, mark the Create an output query of checkbox and select Records.
On the Filters tab, change the Assigned To filter from All to Selected, mark the Query option and select the query you created above.
Click Preview and save the output query.

The output query created will give you quick access to each record with activity to apply. With that said, let's move to the last step in this process:

In Query, open the query created from the Unapplied Credit Report.
On the Output tab, select Record, Full/organization name and any other appropriate fields.
Select the Results tab.
Double click the first record in the query.
On the Record, select the Activity tab and apply the payment or credit.
Click the single right arrow to move to the next record in the query.
Follow steps 5 and 6 until all credits or payments are applied.

Now you are ready to run your statements in confidence! I recommend performing this process each month before you process your statements.

Talk to you soon!