Skip to content
LetSync

QuickBooks Import & Export data | QuickBooks API Integration

  • Home
  • Trial Registration Forms
    • LetSync Desktop/Online
  • Shop – LetSync Desktop
  • Contact Us
  • Forum
    • QuickBooks Integration Forum Registration
    • Register here
    • Password Reset
  • Help Center
  • My account
    • Account details
    • Lost password
    • Customer Code of Conduct Policy
    • Privacy Policy
    • End-User Subscription Agreement (EULA)
    • Refund Policy
  • Cart

Release Notes - LetSync Desktop

1
  • Release Notes

Setting up LetSync Online and QuickBooks Online Integration

15
  • Reconnecting your QuickBooks Online account to LetSync Online
  • Connecting your QuickBooks Online account to LetSync Online
  • Disconnecting your QuickBooks Online account from LetSync Online
  • Databases
  • Tasks
  • Reports
  • Settings
  • Users
  • QuickBooks Online – LetSync Online Data Integration Overview
  • Run Tasks/Reports On Demand
  • LetSync Online Outbound IP
  • Scheduler
  • Authorization Code
  • SQL Server Database Schema Create for QuickBooks Online
  • MySQL Server Database Schema Create for QuickBooks Online

What is LetSync Desktop?

2
  • What is LetSync Desktop?
  • Watch Demo

Getting Started LetSync Desktop

6
  • Starting LetSync Desktop
  • Adding a QuickBooks company file
  • Connecting your database
  • Adding Tasks
  • Running a task
  • LetSync Desktop set up for new customers

Setting up LetSync Desktop

12
  • LetSync Desktop UI
  • Taskbar
  • Quickbooks company files
  • Databases
  • Tasks
  • Settings
  • Move License to another computer
  • Restart LetSync Desktop
  • QuickBooks company file re-Authorization
  • Quantity of records to Request per Query
  • Number of Days In Chunk
  • Quickbook’s little popup “login” message

Log Files LetSync Desktop

1
  • Log Files

Email Notification LetSync Desktop

1
  • Email Notification

Scheduling task to run automatically

2
  • Scheduling task to run automatically
  • Scheduling task using PowerShell

Database Schema LetSync Desktop

16
  • MySQL Connector/Net connection strings
  • SQL Server connection strings
  • Oracle connection strings
  • There are five fundamental table types in the LetSync schema. These are:
  • Primary Keys
  • QuickBooks Desktop API Reference
  • Schema – Relationships
  • Schema – Indexes
  • Schema – Working with Items
  • Custom Fields
  • Schema – Adding Tables and Fields
  • Schema – Report Tables
  • Update to QuickBooks Operations supported by tables
  • MariaDB Settings for LetSync Desktop
  • SQL Server LetSync Desktop Schema Create
  • MySQL Server LetSync Desktop Schema Create
betterdocs-category-icon

Updating QuickBooks

1
  • Overview of Updating QuickBooks

LetSync Desktop Tables schema

116
  • Account
  • AppliedToTxnRet
  • ARRefundCreditCard
  • Bill
  • BillingRate
  • AdditionalContactRet
  • BillPaymentCheck
  • BillPaymentCreditCard
  • BuildAssembly
  • CashBackInfoRet
  • Charge
  • Check
  • Class
  • Company
  • ComponentItemLineRet
  • ContactsRet
  • CreditCardCharge
  • CreditCardCredit
  • CreditMemo
  • CreditMemoLineGroupRet
  • CreditMemoLineRet
  • Currency
  • Customer
  • CustomerMsg
  • CustomerType
  • DataExtDef
  • DateDrivenTerms
  • DefaultUnitRet
  • Deposit
  • DepositLineRet
  • EarningsRet
  • Employee
  • Estimate
  • EstimateLineGroupRet
  • EstimateLineRet
  • ExpenseLineRet
  • InventoryAdjustment
  • InventoryAdjustmentLineRet
  • InventorySite
  • Invoice
  • InvoiceLineGroupRet
  • InvoiceLineRet
  • AdditionalNotesRet
  • BillingRatePerItemRet
  • ItemDiscount
  • ItemFixedAsset
  • ItemGroup
  • ItemGroupLineRet
  • ItemInventory
  • ItemInventoryAssembly
  • ItemInventoryAssemblyLineRet
  • ItemLineRet
  • ItemNonInventory
  • ItemOtherCharge
  • ItemPayment
  • ItemReceipt
  • ItemSalesTax
  • ItemSalesTaxGroup
  • ItemSalesTaxRefRet
  • ItemService
  • ItemSites
  • ItemSubtotal
  • JobType
  • JournalCreditLineRet
  • JournalDebitLineRet
  • LinkedTxnRet
  • OtherName
  • PaymentMethod
  • PayrollItemNonWage
  • PayrollItemWage
  • PrefillAccountRet
  • PriceLevel
  • PriceLevelPerItemRet
  • PurchaseOrder
  • PurchaseOrderLineGroupRet
  • PurchaseOrderLineRet
  • ReceivePayment
  • ReceivePaymentToDeposit
  • RelatedUnitRet
  • Report
  • SalesAndPurchaseRet
  • SalesOrPurchaseRet
  • SalesOrder
  • SalesOrderLineGroupRet
  • SalesOrderLineRet
  • SalesReceipt
  • SalesReceiptLineGroupRet
  • SalesReceiptLineRet
  • SalesRep
  • SalesTaxCode
  • SalesTaxPaymentCheck
  • SalesTaxPaymentCheckLineRet
  • ShipMethod
  • ShipToAddressRet
  • StandardTerms
  • Template
  • Terms
  • TimeTracking
  • ToDo
  • Transaction
  • Transfer
  • TransferInventory
  • TransferInventoryLineRet
  • UnitOfMeasureSet
  • Vehicle
  • VehicleMileage
  • Vendor
  • VendorCredit
  • VendorType
  • JournalEntry
  • LetSync Desktop operational tables
  • ListMerge
  • Schema Differences
  • Pay a Bill with CreditCardCharge/BillPaymentCreditCard
  • Pay a Bill with Check / BillPaymentCheck
  • ExternalGUID

QuickBooks Desktop Reporting

3
  • Report: Payments With Invoices
  • Report: Trial Balance
  • QuickBooks Report Builder

What is LetSync Online?

2
  • What is LetSync Online?
  • LetSync Online Outbound IP

LetSync Online Register

1
  • LetSync Online Register

LetSync Online Tables schema

58
  • Account
  • Bill
  • Bill Payment
  • Class
  • Company Currency
  • Company Info
  • Credit Memo
  • Customer
  • Customer Type
  • Department
  • Deposit
  • Employee
  • Estimate
  • Exchange Rate
  • Invoice
  • Item
  • Journal Entry
  • Payment
  • Payment Method
  • Purchase
  • Purchase Order
  • Refund Receipt
  • Reimburse Charge
  • Sales Receipt
  • Tax Classification
  • Tax Code
  • Tax Payment
  • Tax Rate
  • Tax Service
  • Tax Agency
  • Term
  • Time Activity
  • Transfer
  • Vendor
  • Vendor Credit
  • LinkedTxn
  • BillLineDetail
  • TxnTaxLineDetail
  • BillPaymentLineDetail
  • CreditMemoLineDetail
  • OtherAddress
  • ContactInfo
  • DepositLineDetail
  • EstimateLineDetail
  • InvoiceLineDetail
  • StatusInfo
  • ItemComponentLine
  • JournalEntryLineDetail
  • PaymentLineDetail
  • PurchaseLineDetail
  • PurchaseOrderLineDetail
  • AccountSubType
  • Item Type
  • ItemCategoryType
  • ItemServiceType
  • SpecialItemType
  • PaymentType
  • PaymentMethodType
View Categories
  • help
  • Docs
  • Database Schema LetSync Desktop

Database Schema LetSync Desktop

This schema mirrors the QuickBooks Desktop and is driven directly from the QuickBooks Desktop schema.

  • MySQL Connector/Net connection strings
  • SQL Server connection strings
  • Oracle connection strings
  • There are five fundamental table types in the LetSync schema. These are:
  • Primary Keys
  • QuickBooks Desktop API Reference
  • Schema – Relationships
  • Schema – Indexes
  • Schema – Working with Items
  • Custom Fields
  • Schema – Adding Tables and Fields
  • Schema – Report Tables
  • Update to QuickBooks Operations supported by tables
  • MariaDB Settings for LetSync Desktop
  • SQL Server LetSync Desktop Schema Create
  • MySQL Server LetSync Desktop Schema Create
  • Updating QuickBooks
    • Overview of Updating QuickBooks
  • QuickBooks Desktop Reporting
    • Report: Payments With Invoices
    • Report: Trial Balance
    • QuickBooks Report Builder
Copyright © 2025 LetSync