Skip to main content

How can we help?

Quickbooks manual import

 
  1. Mapped assets, incomes, and expenses to accounts from your Chart of Accounts.

  2. Automatically built Ledger Entries for all your transactions.

For example, I made a payment to an employee, the transaction is labelled 'Salary', and the automated Chart of Accounts mapping is correct.

 

On the transaction page I have this view:

 

In the Quickbooks Ledger Entries report I have this view for the same transaction:

 

This can be directly imported into your Quickbooks Online account.


Generating the Quickbooks Ledger Entries report in Cryptio

Ensure you have done these steps before exporting Ledger Entries:

  1. Ensure you have synced/imported your Chart of Accounts.

  2. Using the Chart of Accounts to set rules to automate the mapping to transactions.
    (Click here, to learn how to do both of these)

  3. Once completed, the software will be able to generate Ledger Entries reports.

To export Ledger Entries, go to the Reports page and then follow these steps:

  1. Click on the + Report button

Using the drawer on the right input this data:

  1. Type select Ledger entries

  2. CSV Format select Quickbooks

  3. The date Range is up to you.

  4. Finally, click Create.


Importing the Quickbooks Ledger Entries report into Quickbooks

Step 1: Log in to your Quickbooks Account

Step 2: Click on the settings icon, then the Import Data button located under Tools

 

Step 3: Click on Journal Entries

 

 

Step 4: Import the cryptio Ledger Entries file (note the date format is yyyy-mm-dd)

 

Step 5: Once imported, click on the Magnifying Glass icon, and click on the Journal Entry to review the entries.

 

 

Step 6: Review the work you have done and when ready click save!