Monday, August 10, 2015

QuickBooks Pro

· Maximum of 3 users
· For up and running businesses
· Sample company files to play with
· Track sales, accounts receivables, taxes & customer payments
· Track expenses, accounts payable & vendor payments
· Import data from excel, Quicken, Microsoft, Office Accounting & prior QB versions
· Batch Invoicing


















· Multi currency
















· Bank reconciliation















· Company Snapshot















· Lead Center















· Journal Entries














· Customizable business templates


















· Easy access reporting (export to excel, print or email)
























· Track & manage inventory & create purchase orders














· Set and manage inventory reorder points


















For any questions, email us at albqbsolutions@gmail.com



Sunday, August 9, 2015

QuickBooks Premier Accountant

QuickBooks Premier Accountant includes all the features of QuickBooks Pro and Premier plus the following functionalities:
  • Maximum of 5 users
  • Audit a company file while client is also working on their file
  • Clear up undeposited funds account
  • Ability to open two company files at the same time
  • Intuit Statement Writer
  • Batch Enter Transactions
  • Client Data review
 

  •  Fixed Asset Manager














  • Fix incorrectly recorded taxes
 

  • Fix unapplied customer payments and credits















  • Reclassify transactions 















  • Working Trial Balance 
















  • Write off invoice















For any questions, email us at albqbsolutions@gmail.com






Thursday, August 6, 2015

QuickBooks Premier

QuickBooks Premier includes all the features of QuickBooks Pro plus the following functionalities:

  • Maximum of 5 users
  • 150+ Industry Specific Reports
  • Track your balance sheet by class such as a location, department, or profit center
  • Budgets, Forecasts and Cash Flow Projector


  • Create Sales Orders and Estimates, track back orders and generate Purchase Orders from Sales Orders and Estimates

  • Build Inventory Assembly and Bills of Materials

  • Reversing Journal Entries


  • Track time and expenses by employee, project, client, or service


  • View customized sales and profitability reports


For any questions, email us at albqbsolutions@gmail.com



















QuickBooks Enterprise 2015 System Requirements

QuickBooks Pro and Premier 2015 System Requirements

Operating Systems Supported:
  • Windows 8, all editions including 64-bit, natively installed 
  • Windows 7, all editions including 64-bit, natively installed 
  • Windows Vista (SP1 or later), all editions including 64-bit, natively installed 
  • Windows Server 2012, Windows Small Business Server 2011, Small Business Server 2008
  • Windows Server 2008 R2, Windows Server 2008, and Windows Server 2003 (SP2), including 64-bit, natively installed
Database Servers:
  • Windowsnatively installed & Windows 8, Windows 7 or Vista (SP1) with UAC on, Windows Server 2011, Windows Server 2008 R2, Windows Server 2008, Windows Server 2008 - Terminal Server Config., Windows Server 2003 (SP2), and Windows Small Business Server 2008

    Note: Windows Home Server Edition is not supported.
Hardware & Operating System Requirements (Client & Server):
  • 2.4 GHz processor minimum
  • 2 GB RAM minimum
  • 4x CD-ROM drive required for CD installations
  • Display optimized for 1024 x 768 screen resolution or higher with up to 2 Extended monitors
  • Best optimized for Default DPI setting (96 DPI or 100%). Additionally, medium DPI (120 DPI or 110%) is supported to ensure an optimal experience for 110% scaling.
  • Windows:
    • U.S. version
    • Regional Settings are supported when set to English (United States) with keyboard setting to U.S. only
    • Administrator Rights required for the server computer when hosting Multi User Access
    • Natively installed
  • Disk space requirements:
    • 2.5 GB of disk space (additional space required for data files)
    • Additional software: 250 MB for Microsoft .NET 4.0 Runtime, provided on the QuickBooks CD
    • Additional requirements  for Intuit Data Protect in QuickBooks Connected Services offerings
      • Require minimum 2.0 GB Ram
      • Twice the size of the largest File set to back up + 100MB or twice the size to restore. The space is only required from the work folder LocalApplicationData+”Intuit\Intuit Data Protect"
Software Compatibility:
QuickBooks is capable of integrating with hundreds of third-party applications. The following integrations are provided with QuickBooks; additional RAM will enhance the use of these features. See Intuit Marketplace for the most up-to-date list.
    • Microsoft Office:
      • Office 2010 and Office 2013/365 (including Outlook 2010 and Outlook 2013) both on 32 and 64 bit.  (Note:  Office 365 is only supported when it is locally installed, not the web version.)
      • Preparing letters requires Microsoft Word 2013, 2010, or 2007.
      • Exporting reports requires Microsoft Excel 2013, 2010, or 2007.
      • Contact Synchronization with Microsoft Outlook requires Outlook 2013, 2010, or 2007.
      • Synchronization with Outlook requires QuickBooks Contact Sync for Outlook(the download is available at no charge).
        Contact Sync does not work with the Microsoft Business Contact Manager Outlook plug-in. If a sync is performed, duplicate records could result  
    • QuickBooks Point of Sale 2014 (V12.0), V11.0 , V10.0
    • Adobe Acrobat Reader: Business Planner functionality and viewing forms requires Adobe Acrobat Reader 5.0 or later.
    • Payroll and other online features and services requires Internet access with at least a 56 Kbps connection speed (DSL or cable modem recommended).
    • TurboTax 2013 and 2014 (Personal and Business)
    • Lacerte 2014 and 2013.
    • Pro-Series tax years 2014 and 2013.
    • QuickBooks for Mac 2015.
    • Gmail, Yahoo Email, Windows Mail, Hotmail and AOL.
    • Internet Explorer 11, 10, and 9.
Firewall and Anti Virus Software Compatibility:
QuickBooks Pro 2015 has been tested with the following firewall and antivirus products.

Note: In some cases, it may be necessary to adjust settings in these products to ensure the best possible performance with QuickBooks.
  • Windows Server Firewall (all editions)
  • Windows 8 and 8.1 Firewall (all editions)
  • Windows 7 Firewall (all editions)
  • Windows Vista Firewall (all editions)
  • Microsoft Security Essentials
  • Avast
  • Windows Defender
  • AVG
  • Symantec
  • ESET
  • Avira
  • Kaspersky
  • McAfee
  • Bitdefender
  • Norton
Note: QuickBooks will work with systems running RAID (Redundant Array of Inexpensive Disks) but this is not recommended because performance issues may cause QuickBooks to operate slowly.

Wednesday, July 29, 2015

Difference between QuickBooks UK and US Version

There is not much difference between the two versions since the accounting standards around the world are almost the same. Here are the notable differences:

UK Version
  • Automatically computes VAT Input and VAT Output. You can input the price in the invoice or bill either VAT inclusive or VAT exclusive and it will automatically computes VAT.
  • Uses the British Balance Sheet as the default format in which the report starts with the non current assets but this can be changed in the settings to our usual Balance Sheet format.
  • Spells CHEQUES this way
  • Spells FAVOURITES this way
  • When you check Programs & Features in the Control Panel, the publisher is Intuit Limited

US Version
  • Utilizes the Sales Tax functionality where the tax is as an add on to the sales price. You have to input the VAT exclusive price in the invoice or sales receipt to compute VAT output.
  • The Balance Sheet format is according to liquidity
  • Spells CHECKS this way
  • Spells FAVORITES this way
  • When you check Programs & Features in the Control Panel, the publisher is Intuit Inc.

For any questions, email us at albqbsolutions@gmail.com



Thursday, July 23, 2015

Applying Excess Credits for One Job to Another in QuickBooks

Our client wrote to ask our help. He has a customer with three jobs, all of which are completed. Two of the jobs have balances due, but the third job has a substantial outstanding credit for items that were returned after the job was finished. He wants to use the credit on the third job to pay off all of the first job and part of the second job. He wants to have a logical "trail" to explain to the customer and to his accountant.

We found a way to accomplish this without changing the history of the original transactions that were applied to the three jobs. For this example, we used our customer named Contractor Larry, who had three jobs: Job01, Job02, Job03. These are the balances for each job.


That credit amount is sufficient to pay off Job01 in full, and apply the remaining credit balance to the open balance for Job02. We needed a place to "trade out" the credit from one job to another, so we created an account of the type Other Current Liability, which we named Customer Credits Exchange. The first step was to move the credit amount into the Customer Credits Exchange account (so that we could use it for the other jobs), without removing the credit's history from Job03. We accomplished that with a journal entry that debited $228.80 to Accounts Receivable and credited the same amount to the Customer Credits Exchange account. Entering the job in the Name column created a receivable (invoice) against which we could wash the outstanding credit.


We opened the Receive Payments window and selected Job03, to display the invoice created by the debit side of the journal entry. We left the Amount field at 0.00 and clicked the Discounts & Credits button to apply the existing credit to the new charge.



At this point, Job03 is at a zero balance, the job history has all the transactions that were applied, and the Customer Credits Exchange account has a credit balance of $228.80; we've moved the job credit to the balance sheet.

Next, we have to use $205.00 of the credit balance in the Customer Credits Exchange account to pay off Job01. In the Receive Payments transaction window, we selected Job01 to display the current balance due. Leaving the Amount field at 0.00, we clicked Discounts & Credits and created a discount against the invoice in the amount of $205.00. We used the Customer Credits Exchange account as the Discount Account.


Job01 now had a zero balance and $23.80 remained in the Customer Credits Exchange account, which we applied against the balance for Job02 as a discount (same steps as applying the discount to Job01). The Customer Credits Exchange account has been emptied, and the credit for Job03 has been applied to the other jobs.


For any questions, email us at albqbsolutions@gmail.com











Tuesday, July 21, 2015

Inventory Freebies

How do you record it in QuickBooks when you give out inventory as freebies, samples, donations to charity, giveaways and the like?

When you remove inventory (whether it's sold or given away) your inventory asset account is decremented. The other accounts involved in the transaction vary, depending on the method you use to track the freebie. Let's look at what happens when you sell an inventory item. QuickBooks makes the following postings (I'm ignoring VAT issues just to make this simple):
  • Credits the Inventory Asset Account for the current average cost of the item (and reduces the Quantity Available for the item).
  • Debits the Cost of Goods Sold account for the current average cost of the item.
  • If the sales transaction is an Invoice, debits A/R for the sales price; if the sales transaction is a Sales Receipt, debits the bank account or the Undeposited Funds account (depending on your setup).
  • Credits the sales price to the Income account linked to the item.
The same postings take place when you give away an inventory item, except the amounts of the postings involving the sales price is zero.

Using an Inventory Adjustment Transaction

An inventory adjustment is the fastest method if you don't need to track the details of the transaction in reports (such as the customer name). Here are the steps:

1. Choose Inventory Activities (from Home Page) | Adjust Quantity/Value on Hand.
2. In the Adjustment Account field, enter the appropriate account. If you're donating an inventory item to a charity, post the transaction to the charitable contribution expense. If you're sending a sample or a giveaway, use the Advertising or Marketing expense account.
3. Remove the item from inventory by entering the new quantity (current quantity minus one) in the New Qty column, or by entering -1 in the Qty Difference column.
4. If you're tracking classes, enter the appropriate class. QuickBooks debits the expense account and credits the inventory account, and also reduces the Quantity on Hand for the item.

Using a Sales Transaction

Use a sales transaction (either an Invoice or a Sales Receipt) if you want to track the customer and the reason for the freebie in reports. Use the following guidelines to create the transaction:
  • Enter the item and quantity.
  • Change the Amount column to 0.00.
  • Enter the Class if you're tracking classes.
  • Enter Memo text to describe the reason for the freebie (e.g. Promotion, or Contribution).
Note that there are two places to enter Memo text on a sales transaction: In the Description Field in the line item, and in the Memo field at the bottom of the transaction window. When you create reports that include the Memo column, the text in the Description field takes precedence over the text in the Memo field. If the Description field contains the item's description, that's the text that appears on reports, and for this purpose you should replace the text with the Memo text that describes the reason for the freebie so you get the reports you need.

If you're sending the freebie to an existing customer, use the customer in the transaction. If the item is going to someone who is not a customer, use a generic customer account (named Samples, Potential Customer, Donations, etc.) in the transaction. (It's not a good idea to fill your customer list with names that aren't really customers.)

For generic customers, enter the real name and address in the Customer Information block and select NO when QuickBooks asks if you want to change the address information for this generic customer. The information will remain on the sales transaction record and you can view it by opening the transaction. QuickBooks posts the transaction the same way it posts a normal, regular sale. Cost of Goods Sold is debited for the current average cost of the item, and the Inventory Asset account is credited for that value. In addition, the Quantity on Hand is decremented from the item's record. The amount posted to the income account linked to the item is Zero, and the amount posted to A/R (if you used an invoice) or Undeposited Funds/Bank Account (if you used a sales receipt) is zero.

Creating Reports to Track Freebies

You can track details about the freebies you use in a sales transaction by creating reports that display the information you need. You need a report for promotional freebies and a separate report for contributions. Here are the steps:

1. Choose Reports | Sales | Sales by Item Detail.
2. Choose Modify Report.
3. In the Filters tab configure the following filters:
  • Amount. Select Equals (=) and enter 0.00.
  • Item. Select All Inventory Items.
  • Memo. Enter the memo text for this report (see the information about Memo text in the previous section).
4. In the Header/Footer tab change the name of the report to match its content (e.g. Promotion Freebies or Contribution Freebies.
5. Click OK and memorize the report so you don't have to go through this configuration work in the future.

For any questions, email us at albqbsolutions@gmail.com