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

Importing a GL File into Quickbooks Online

I have a number of clients that use Quickbooks online for their General Ledger, but use an outside vendor for processing their payroll.  They need a way to import the results of their payroll into quickbooks.  I found a lot of articles oh how this is accomplished, but none that define the file specs for a .csv file.  Does anyone have this information?  I need to know what needs to be included.  For example:

What goes in

Column A:  Account name/number?

Columb B:  Account description?

Column C: Entry Date?

Column Debits - Credits?

 

Any help would be appreciated.

MJA

2 Comments 2
Erika_K
QuickBooks Team

Importing a GL File into Quickbooks Online

Thanks for getting in touch with us, MJA64. I'll share information about importing General Ledger (GL), including their payroll data. 

 

Downloading GL and payroll data in QuickBooks isn't currently available. Here are the following information we can bring into the program: 

 

  • Bank Data
  • Customers
  • Vendors
  • Chart of Accounts
  • Products and Services
  • Invoices
  • Journal Entries

 

image.png

In the meantime, we can bring your payroll data by creating journal entries inside your account. However, if you have a QBO Payroll subscription, you can directly input their pay history using prior payroll

 

Concerning your GL information, we manually upload the transactions to QuickBooks Online (QBO) using a CSV file format and then categorize them to show them to the GL reports. 

 

I'll show you how: 

 

  1. Go to Bank transactions
  2. On the Link account dropdown, hit Upload from file.
    image.png
  3. Choose between Drag and drop or select files to select the file you download from the bank, then hit Continue.
    image.png
  4. In the QuickBooks Account dropdown, choose the account you want to upload the transaction into, then click Continue.
    image.png
  5. Map the transactions you'd want to import, then hit Continue.
    image.png
  6. Select the transactions you'd want to import, then Continue.
    image.png
  7. If you choose to accept the transaction, click Yes.
    image.png
  8. After that, hit Done.
    image.png

 

Finally, we can also use third-party applications or an importer tool to bring the GL together with the payroll data to QuickBooks Online (QBO). You can look for one through the QuickBooks App Store or directly find one on the Apps menu in QBO. 

 

Refer to the steps below: 

 

  1. Go to Apps and select Find apps.
  2. Search for a keyword in the search bar and hit Enter.
  3. Choose an app and click Get app now to integrate.

 

Comment below if you encounter any further inquiries or require additional guidance regarding the process of downloading various data sets into QBO, MJA64 don't hesitate to share your questions. I'm always here to support you every step of the way. Keep safe and take care always! 

SIAB
Level 4

Importing a GL File into Quickbooks Online

@MJA64 

You can prepare your JE data with the following template

RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
10101/10/2020Wire TransferFALSE  Savings-50.00Credit Savings   
10101/10/2020Wire TransferFALSE  Checking50.00Debit Checking   
10201/10/2020Wire TransferFALSE  Savings200.00Debit Savings   
10201/10/2020Wire TransferFALSE  Checking-200.00Credit Checking   

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

 

Need to get in touch?

Contact us