cancel
Showing results for 
Search instead for 
Did you mean: 
DJ0624
Level 1

FACTS Tuition Management & QB

Hi, I work for a private school that uses FACTS Tuition Management for all of their tuition, activity and lunch payments. Currently we hand key each transaction into QB Desktop Enterprise. Is there anyone out there who is either (1) doing an API from FACTS to QB Enterprise Desktop or (2) doing a batch upload of invoices. I would like to move the school away from hand keying each transaction into QB. Thanks!

2 Comments 2
jeanbiverly_
QuickBooks Team

FACTS Tuition Management & QB

I'm here to address your API and invoice concerns, @DJ0624.

 

Regarding your first question, we have a separate and dedicated forum that handles API queries for QuickBooks Desktop (QBDT). Let me connect you with our Intuit Developers team so your inquiry will be addressed accordingly.

 

Here's how:

 

  1. Go to this link: https://help.developer.intuit.com/s/.
  2. Scroll down and click the Contact Support button.
  3. Follow the prompts displayed on the screen to continue.

 

A1.png

 

As for your second question, it's possible to batch-upload invoices in QBDT. I can guide you through the process.

 

You can follow these steps:

 

1. Navigate to the Customers menu and select Create Batch Invoices.

2. Ensure your terms, sales tax rate, and send method are updated for all customers you are sending batch invoices to by selecting each of them:

  • Double-click on the customer.
  • Go to the Additional Info tab and modify the needed details.

3. Determine your desired customers by searching or selecting/creating a Billing Group, then click Next.

 

 

4. Pick your preferred line items and template.

5. You can input a message if you want, then select Next.

6. Assess the list of invoices to be produced, then choose Create Invoices.

7. Print or email as appropriate, then hit Close.

 

 

For more detailed information, visit this article: Enter transactions by batch in QuickBooks Desktop.

 

In case you want to receive invoice payments in QBDT, check out this article for more guidance: Record an invoice payment.

 

Feel comfortable to return to this thread if you have other concerns about API and uploading invoices by batch in QBDT. I'll be here for you, DJ0624.

4Gal
Level 11

FACTS Tuition Management & QB

@DJ0624 

You can prepare your Invoice + Receive Payments OR only Sales Receipt data in the following template and use an importer tool to proceed.

 

Invoice

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non

 

Receive Payment

CustomerCheck NumberTransaction DatePayment MethodMemoApply to Invoice (blank auto-applies)AmountDeposit ToDiscount AmountDiscount AccountDiscount ClassAR AccountExchange Rate
Anne's Bakery12301/11/2020Check 10010000Checking     
John's Barber Shope99901/11/2020Check 101500Checking     

 

Sales Receipt

CustomerTransaction DateRefNumberPayment MethodCheck NumberClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceDeposit ToIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000Checking             Non
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50Checking             Non
John's Barber Shope02/09/2020101Check89  Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500Checking             Non
Main St Bank03/09/2020102Check18  N#########Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonDoor1Door300Checking             Non
Main St Bank03/09/2020102Check18  N#########Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonHandles1Handle10Checking             Non

 

It's a $199 one time license and you can get $100 to purchase it a partner.

https://get.transactionpro.com/qbd

 

Need to get in touch?

Contact us