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

  • Release Notes

Setting up LetSync Online and QuickBooks Online Integration

  • Connecting your QuickBooks Online Company File to LetSync Online
  • Disconnecting your QuickBooks Online Company File from LetSync Online
  • Reconnecting your QuickBooks Online Company File to LetSync Online
  • Authorization Code
  • LetSync Online Outbound IP
  • Users
  • QuickBooks Online – LetSync Online Data Integration Overview
  • SQL Server Database Schema Create Statement for QuickBooks Online
  • MySQL Server Database Schema Create Statement for QuickBooks Online

What is LetSync Desktop?

  • What is LetSync Desktop?
  • Watch Demo

Getting Started LetSync Desktop

  • LetSync Desktop set up for new customers
  • Activate LetSync Desktop License Key
  • Adding a QuickBooks Desktop Company File
  • Adding a QuickBooks Online Company File
  • Adding Databases
  • Adding Tasks
  • Running a Task

LetSync Desktop UI Operational Guide

  • LetSync Desktop UI
  • Taskbar
  • Quickbooks Company Files
  • QuickBooks Company File re-Authorization
  • Databases
  • Tasks
  • Settings
  • Account
  • Restart LetSync Desktop
  • Move License to Another Computer
  • Quantity of records to Request per Query
  • Number of Days In Chunk

Log Files LetSync Desktop

  • Log Files

Email Notification LetSync Desktop

  • Email Notification

Scheduling task to run automatically

  • Scheduling task to run automatically
  • Scheduling task using PowerShell

Database Schema for QuickBooks Desktop

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

Updating QuickBooks

  • Overview of Updating QuickBooks

LetSync Desktop Tables schema

  • Schema Differences
  • LetSync Desktop operational tables
  • Account
  • AdditionalContactRet
  • AdditionalNotesRet
  • AppliedToTxnRet
  • ARRefundCreditCard
  • Bill
  • Pay a Bill with CreditCardCharge/BillPaymentCreditCard
  • Pay a Bill with Check / BillPaymentCheck
  • BillingRate
  • BillingRatePerItemRet
  • 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
  • ExternalGUID
  • InventoryAdjustment
  • InventoryAdjustmentLineRet
  • InventorySite
  • Invoice
  • InvoiceLineGroupRet
  • InvoiceLineRet
  • ItemDiscount
  • ItemFixedAsset
  • ItemGroup
  • ItemGroupLineRet
  • ItemInventory
  • ItemInventoryAssembly
  • ItemInventoryAssemblyLineRet
  • ItemLineRet
  • ItemNonInventory
  • ItemOtherCharge
  • ItemPayment
  • ItemReceipt
  • ItemSalesTax
  • ItemSalesTaxGroup
  • ItemSalesTaxRefRet
  • ItemService
  • ItemSites
  • ItemSubtotal
  • JobType
  • JournalEntry
  • JournalCreditLineRet
  • JournalDebitLineRet
  • LinkedTxnRet
  • ListMerge
  • 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

QuickBooks Desktop Reporting

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

What is LetSync Online?

  • LetSync Online Outbound IP
  • What is LetSync Online?

LetSync Online Register

  • LetSync Online Register

LetSync Online Tables schema

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

QuickBooks Online Integration

  • Setting up the QuickBooks Online integration
View Categories
  • help
  • Home
  • LetSync Desktop UI Operational Guide

LetSync Desktop UI Operational Guide

This topic will guide you in how to interact with LetSync Desktop UI

  • LetSync Desktop UI
  • Taskbar
  • Quickbooks Company Files
  • QuickBooks Company File re-Authorization
  • Databases
  • Tasks
  • Settings
  • Account
  • Restart LetSync Desktop
  • Move License to Another Computer
  • Quantity of records to Request per Query
  • Number of Days In Chunk
Copyright © 2025 LetSync