wehuberconsultingllc.com

A couple of years ago I created some spreadsheets to help me migrate data into QuickBooks. I set up a worksheet that followed the IIF format and then saved it as a tab delimited file. The biggest problem was that one row of data required three rows in the IIF format. If you try and [...]

[Read more →]

A big thank you goes out Aaron for his automated cleanup tool to remove the .NET Framework 1.0, 1.1, 2.0, 3.0 and 3.5. Yesterday I found myself in “No Man’s Land”. My PC was trying to install Microsoft .NET Framework 2.0 Service Pack 1(KB110806). It did not work and complained about not finding 2.0a.  The [...]

[Read more →]

For several years I have successfully used the QuickBooks IIF format to import bills, checks, and employee hours. I have been less successful with invoices and I was unable to import payments. Several times I considered writing a C# or VB program to import the data but I backed off because it looked like it [...]

[Read more →]

A while back I wrote a post called, “Update to Excel Macro to import IIF transactions“. In it I talked about a macro I was working on to import IIF transactions into QuickBooks. I had intended to share the macro once I got finished testing it. Well, I have finished testing it. There is good [...]

[Read more →]

Microsoft Introduces New Accounting Software and Services for Small and Home-Based Businesses Microsoft Corp. announced the availability of Microsoft® Office Accounting Express 2007, financial management software designed for early startups and home-based businesses that currently use pen and calculator or spreadsheets to run their operations. Office Accounting Express 2007 consists of desktop software available as [...]

[Read more →]

With a shout out to Mike in the blog comments… he said “I was troubleshooting an installation of QB07 on a 2003 Terminal Server. I had all the security modifications that I have used for the previous versions and it still wouldn’t work. What I discovered is that normal users don’t have but need rights [...]

[Read more →]

Mozilla – Home of the Firefox web browser and Thunderbird email client The number one reason for me to update to version 2 of Firefox is spell check. This should improve my blog writing throughout the internet. It will probably be some time for me before I update IE6  to IE7. I am still using [...]

[Read more →]

  A while back I wrote a new macro to import IIF transactions, New Excel Macro to import IIF transactions. Last week I put it to the test and found several bugs. All of the bugs were minor but annoying. They created a lot more work for me but I am hopeful the next time I [...]

[Read more →]

I got an email recently from someone who was trying to import QuickBooks IIF transactions. Although I could not help this person with the problem, I did get motivated to write an Excel macro to import IIF transactions. One of the more tedious tasks I do as Treasurer for our Habitat affiliate is inputting payment data [...]

[Read more →]

The problem with importing data into QuickBooks is their funky multi-line IIF file format. For each transaction(e.g. invoice) in the single row CSV format you need to create three or more rows in IIF format. For me I import the CSV file into one worksheet and create a separate worksheet I call IIF for the [...]

[Read more →]

This week I sat in on a Small Business Accounting webcast using Live Meeting. Participating in the using Live Meeting was pretty cool! The combination of sound, slides, and chat facilities to ask questions worked for me. I cannot say I paid 100% attention but I did get enough out of the presentation to get [...]

[Read more →]

When using QuickBooks 2006 or QuickBooks Enterprise Solutions 6.0 in a multi-user environment, *the one best thing to know is that the new QuickBooks database requires new installation procedures with all machines running on Release 3 or above. To help you support your clients with QuickBooks 2006 in a multi-user environment, Intuit offers: * White [...]

[Read more →]

Top QuickBooks Support Issues – Restricted Access to Windows User Account Your user account for Windows was created with Restricted access to system resources. This will prevent QuickBooks from operating properly. Please contact your system administrator and ask him or her to grant you Standard user rights. The easiest way to fix this problem is [...]

[Read more →]

Local Admin/Power User Hall of Shame This site contains a partial list of programs that require Admin rights and do not support current security patches. The SBS Diva was writing about a vendor whose program support would not support users who had installed the current set of XP security patches. It also has instructions on [...]

[Read more →]

Excel Round time to the nearest quarter hour I screwed up with my paysheet calculation for one of our employees on our farm for the last pay period. I was calculating the number of hours worked in my head. One of our employees pointed out the mistake and I decided to minimize future mistakes by [...]

[Read more →]

The business of trust So what are some issues small business owners should be concerned about when they let someone else do the bookkeeping? If you answer “yes” to any of these, you may have issues in segregation of duties: Is the person who handles your cash also responsible for recording the cash? Does the [...]

[Read more →]

I have been working hard at finalizing the 2003-2004 financial statements for our Habitat affiliate. I am the treasurer now and I need to file the 2003-2004 Form 990. The problem is that the final financial reports coming out of QuickBooks were not to my liking. The previous treasurers/accounting firms appear to have used a [...]

[Read more →]

Yesterday I stored a QuickBooks backup for our Habitat affiliate on my internal companyweb website. I then went into the office and downloaded the file using the secure version of the website that is accessible from the internet. I restored the company file, made my changes, backed up the company file, and uploaded the file [...]

[Read more →]

Yesterday I removed a few programs I was not using and ran Spybot to check and clean my PC. Somehow I broke QB 2004 in the process. When I tried to open it I got this message: an unrecoverable error has occoured exception MSXML could not CoCreateInstance HRESULT=80040154 thrown with error code-2147221164 Function: ADR::Repository DoInitialLoad [...]

[Read more →]

I am finally at the end of the project to transfer the accounting data from Peachtree to QuickBooks. The biggest change was to change the account and job names. I opted to follow the recommendations of Intuit and others to use the Unified Chart of Accounts. This chart of accounts is very close to the [...]

[Read more →]