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

Converting an imported journal entry from Paylocity payroll to a check transaction

I work for a nonprofit that has an abundance of government contracts that need meticulous tracking. 

I’ve developed a system with our current QuickBooks Premier Desktop to enter all new government contracts as Customer Jobs with Estimates so we can run Job Estimates vs. Actuals reports for tracking. The challenge is with Customer Jobs, Items need to be used versus Expenses, which is easiest enough to do except for the GL import we get from our payroll provider, Paylocity. And since payroll is our biggest expense, we’re stuck with doing endless JE’s to allocate expenses to contracts. I’m looking for a better and cleaner way. It looks like there's a QB compatible app called Transaction Pro that might be able to assist with this, but I'm wondering if anyone out there has experience tackling this challenge? 

2 Comments
Highlighted
Moderator

Converting an imported journal entry from Paylocity payroll to a check transaction

It's good to have you here, @nwhitlock,

 

Normally, the type of transactions received in QuickBooks as long as it follows the default template will have the same format when imported. If you need an app to convert them when imported is through a third-party app.

 

We have this website where you can find tools that's right for you. Click this link to visit our site: https://desktop.apps.com/home

 

If you need help with app suggestions and integrations, we have a separate forum called Intuit Developers. This is where you can find and connect with brilliant developers like you. 

 

They can help with app recommendations, give real-time advice with tools that's perfect for you. You can also take part with our software developments and innovate business applications for QuickBooks.

 

I'm adding these links below for you to get in touch with them:

 

Ask questions to our developers: Intuit Developer Support

Create your Developer profile: Create an Intuit developer account

 

If you have other questions or need further assistance with anything in QuickBooks, I'll always be here for you. Have a nice day!

Highlighted
Level 14

Converting an imported journal entry from Paylocity payroll to a check transaction

@nwhitlock 

You may utilize TP as one of the importer tools

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Prepare the Checks data with following template

Bank AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerUnit of MeasureItems BillableCurrencyExchange Rate
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel25John's Car             
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel50Karen's Car             
CheckingMichael's Fine Cabinetry30/09/2020101 Unitel12 Smith Ave  AnywhereNH22222USA       Cabinets10Cabinets150 Baker, Chris:Family Room Y  

Need to get in touch?

Contact us