Skip to content
English
  • There are no suggestions because the search field is empty.

How do you set up the accounting to work with Quickbooks?

Our accounting system is an accounts receivable system, which may or may not fit into how you do Quickbooks.

  It will not work with the QB web version, as even the desktop version of Quickbooks is not compatible with

 the web version of Quickbooks.

The accounts that will be brought into Quickbooks will be your school accounts; the family accounts are

setup to keep track of the financials for the families. When you setup your School | Chart of Accounts 

(General, Childcare, Cafeteria, Tuition13, etc) you need to set these accounts up with the Quickbooks name.

To create the account you will go to Financial| Accounting Mgr| School| Chart of Accounts, click on blue 

New Account account button, and enter an Account Number, a Name, Description, Quickbooks Exact Name and 

class, typically School.

You need to also have your Families| Accounts create to which charges will be made and payments received; 

each Family Account tied to the School side Income Account. When you receive money from a family you will 

credit the appropriate Family Account(s) which will then automatically add to the attached School Income Account.

 
Financial| Accounting Mgr| Reports| School Accounts Export  (Export School Accounts to 

Quickbooks IIF or CSV File) is the report you will use for exporting transactions from Sycamore Education to 

Quickbooks. This report is run by date range (Stop and Start Dates) and will list the TRNSTYPE, DATE, ACCNT, 

AMOUNT, and MEMO for example: TRNS GENERAL JOURNAL 08/13/2009 Tuition -500.00 Beckner, 

Aaron & Karen: Payment - August Check# 2584.

 In the upper right there is a blue Export button which you will use to download these transactions and save

off your IIF or CSV file.  Remember where you save this file, as you will then need to find it to import into 

Quickbooks.