Supplemental guide lesson 2 import list data module

This preview shows page 68 - 71 out of 84 pages.

Supplemental Guide Lesson 2: Import List Data Module 10: Complex Conversions 66 10. Click Import . If any of the records do not import, you will be notified and given the opportunity to correct them and re-import. The QuickBooks Online sample company file can be used to test this import tool. Your data is not saved when you exit the QuickBooks Online sample company. T IP : Various apps are available to import transactions from Excel or CSV. Go to apps.com to research.
Supplemental Guide Lesson 2: Import List Data Module 10: Complex Conversions 67 Importing invoices using QuickBooks Online Advanced When using QuickBooks Online Advanced you can import invoices from a CSV file (but not Excel as you can do with the other lists). There must be entries in the following columns: Invoice Number, Customer, Invoice Date, Due Date and Item. There cannot be more than 1000 lines. There is an import guide you can download as well as a sample file. If you want your own invoice numbers to be imported, make sure to turn on Custom transaction numbers in Account and Settings. The products and services must already be entered in QuickBooks Online, but the import can add new customers. As with the other lists, when you upload, before the import, you will map the invoice fields with the CSV column.
Supplemental Guide Lesson 3: Begin from Scratch – Opening Balances Module 10: Complex Conversions 68 Lesson 3: Begin from Scratch – Opening Balances Existing businesses that decide to start using QuickBooks Online by entering beginning balances (instead of importing historical data) will need to gather pertinent information, record beginning balances, and record any other open posting and non-posting information needed in QuickBooks Online as of the start date. The start date is the day you want to start entering transactions. However, when you are entering opening balances, these should be dated before the start date. G ATHER B ALANCES To ensure the opening balances are correct, you will need the following: Trial balance – Determine the start date for the new QuickBooks Online company; obtain the trial balance for the prior period Open transactions – Compile all outstanding transactions that haven’t been reconciled, including checks, deposits, credit card charges and credit card credits. Gather all open accruals that haven’t been paid, including accounts receivable, accounts payable and sales tax payable Inventory detail – Gather all information about inventory items, including quantity on hand, sales price, taxable status and cost Unbilled billable time and charges – Assemble a list of time and charges that are billable to customers who have not yet been billed and are not included in the lists above of open checks/deposits or open A/R or A/P NOTE: If the prior period’s ending balances which are being used as the beginning balances for the QuickBooks Online start date were at year-end, be sure the adjusting entries were recorded in the old

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture