ALT Project Management: Issueshttps://project.altservice.com/https://project.altservice.com/favicon.ico?16163160252016-04-13T03:23:21ZALT Project Management
Redmine FreeBSD Administration - Feature #797 (Closed): Recover Files From a ZFS Snapshothttps://project.altservice.com/issues/7972016-04-13T03:23:21ZDaniel Curtistechsupport@altservice.com
<p>I accidentally deleted a bunch of important files from a jail that was running FreeNAS 9.3; but will work on FreeBSD as well. Luckily, I had setup my jails to have periodic snapshots taken for just this very reason.</p>
<a name="ZFS-to-the-rescue"></a>
<h1 >ZFS to the rescue!<a href="#ZFS-to-the-rescue" class="wiki-anchor">¶</a></h1>
<ul>
<li>Log into the FreeNAS administration panel and open a <strong>Shell</strong>.</li>
</ul>
<ul>
<li>Check the status of the <ins>snapdir</ins> for the examplejail jail zvol:<br /><pre>
zfs get snapdir zpool/jails/examplejail
</pre>
<ul>
<li><em>Example output</em>:<br /><pre>
NAME PROPERTY VALUE SOURCE
zpool/jails/examplejail snapdir hidden default
</pre></li>
</ul></li>
</ul>
<ul>
<li>Set the <ins>snapdir</ins> value to visible:<br /><pre>
zfs set snapdir=visible zpool/jails/examplejail
</pre></li>
</ul>
<ul>
<li>Check which snapshots are available:<br /><pre>
ls /mnt/zpool/jails/examplejail/.zfs/snapshot/
</pre>
<ul>
<li><em>Example output</em>:<br /><pre>
auto-20160330.0900-2w auto-20160405.0900-2w auto-20160411.0900-2w
auto-20160331.0900-2w auto-20160406.0900-2w auto-20160412.0900-2w
auto-20160401.0900-2w auto-20160407.0900-2w
auto-20160404.0900-2w auto-20160408.0900-2w
</pre></li>
</ul></li>
</ul>
<ul>
<li>Now use rsync to copy the files back to the original jail:<br /><pre>
rsync -avh -n /mnt/zpool/jails/examplejail/.zfs/snapshot/auto-20160411.0900-2w/var/vmail/vmail1/example.com/bob/ /mnt/zpool/jails/examplejail/var/vmail/vmail1/example.com/bob/
</pre>
<ul>
<li><strong>NOTE</strong>: Make sure to <strong>remove</strong> the <code>-n</code> (dryrun) flag to run the sync for real, or else you won't actually be copying the data.</li>
</ul></li>
</ul>
<ul>
<li>When the sync is complete set the example jail zvol <ins>snapdir</ins> property back to hidden:<br /><pre>
zfs set snapdir=hidden zpool/jails/examplejail
</pre></li>
</ul>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="https://www.freebsd.org/doc/handbook/zfs-zfs.html">https://www.freebsd.org/doc/handbook/zfs-zfs.html</a></li>
<li><a class="external" href="https://wiki.freebsd.org/ZFSQuickStartGuide">https://wiki.freebsd.org/ZFSQuickStartGuide</a></li>
</ul> Windows Administration - Bug #700 (Closed): Outlook Error 0x800CCC0F Preventing Synchronizing of ...https://project.altservice.com/issues/7002015-11-24T22:19:19ZDaniel Curtistechsupport@altservice.com
<a name="The-Symptoms"></a>
<h2 >The Symptoms<a href="#The-Symptoms" class="wiki-anchor">¶</a></h2>
<p>I encountered a problem with Microsoft Outlook 2010 where sending or receiving email from a certain email account resulted in an error 0x800CCC0F pop up.</p>
<p>The email account that was producing the pop up was a POP3 account which had recently expired its hosting and its account had probably been deleted on the server side. The new IMAP email account had been set up with the same client, however sent email messages were consistently being sent from the old POP3 account and thus not getting sent (a very serious problem). Further, messages in the old POP3 folders could not be copied or moved over to the new IMAP account folders.</p>
<a name="The-Fix"></a>
<h2 >The Fix<a href="#The-Fix" class="wiki-anchor">¶</a></h2>
<p>After looking around on the Internet, I found a comment on the TechNet forums that mentioned changing some advanced sending/receiving settings. Since the old POP3 account is around only for archival reasons, it does not need to send or receive email.</p>
<ol>
<li>Go to <ins>File -> Options -> Advanced</ins> and click on the <strong>Send/Receive</strong> button.</li>
<li><strong>Edit</strong> the <ins>All Accounts</ins> group.</li>
<li>Select the desired <ins>POP3 Account</ins> and uncheck both <strong>Send mail items</strong> and <strong>Receive mail items</strong>.</li>
</ol>
<p>From now on Outlook will not send or receive mail from the archived POP3 accounts.</p>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="https://social.technet.microsoft.com/Forums/office/en-US/e7fb7a16-d7c4-4f5c-ae18-944277e0e307/error-synchronizing-subscribed-folders-in-ms-outlook-2010">https://social.technet.microsoft.com/Forums/office/en-US/e7fb7a16-d7c4-4f5c-ae18-944277e0e307/error-synchronizing-subscribed-folders-in-ms-outlook-2010</a></li>
</ul> FreeBSD Administration - Support #667 (Suspended): Install FreeSWITCH and FusionPBX on FreeBSDhttps://project.altservice.com/issues/6672015-10-01T22:42:31ZDaniel Curtistechsupport@altservice.com
<p>This is a guide for setting up FreeSWITCH with Nginx, PostgreSQL, and FusionPBX on FreeBSD 9.</p>
<a name="Prepare-the-Environment"></a>
<h2 >Prepare the Environment<a href="#Prepare-the-Environment" class="wiki-anchor">¶</a></h2>
<ul>
<li>Make sure the system is up to date:<br /><pre>
pkg update && pkg upgrade && portsnap fetch extract
</pre></li>
</ul>
<ul>
<li>Install a few dependencies:<br /><pre>
pkg install portmaster screen sox cmake autoconf automake lua51 curl git gmake jpeg ldns libedit binutils freetype2 libtool openssl pcre pkgconf flex speex sqlite3 wget subversion postgresql94-client sofia-sip x264 libvpx opus ffmpeg
pkg2ng
</pre></li>
</ul>
<a name="Install-FreeSWITCH"></a>
<h2 >Install FreeSWITCH<a href="#Install-FreeSWITCH" class="wiki-anchor">¶</a></h2>
<p><strong>NOTE</strong>: I could not build FreeSWITCH from ports, so this guide will compile from GitHub.</p>
<ul>
<li>Make a source directory and switch to it:<br /><pre>
mkdir /usr/local/src && cd /usr/local/src
</pre></li>
</ul>
<ul>
<li>Clone the latest version of freeswitch:<br /><pre>
git clone -b v1.6 https://freeswitch.org/stash/scm/fs/freeswitch.git
</pre></li>
</ul>
<ul>
<li>Build and install freeswitch:<br /><pre>
./bootstrap.sh -j
./configure --enable-core-pgsql-support
gmake
gmake install cd-sounds-install cd-moh-install
</pre>
<ul>
<li>While running gmake, I encountered an error. To work around this I disabled mod_fsv:<br /><pre>
sed -i '' -e 's/applications\/mod_fsv/#applications\/mod_fsv/' modules.conf
</pre></li>
</ul></li>
</ul>
<a name="Freeswitch-rc-script"></a>
<h3 >Freeswitch rc script<a href="#Freeswitch-rc-script" class="wiki-anchor">¶</a></h3>
<ul>
<li>Create the rc script:<br /><pre>
vi /usr/local/etc/rc.d/freeswitch
</pre>
<ul>
<li>And add the following<br /><pre>
#!/bin/sh
#
# PROVIDE: freeswitch
# REQUIRE: LOGIN cleanvar
# KEYWORD: shutdown
#
# Add the following lines to /etc/rc.conf to enable freeswitch:
# freeswitch_enable: Set it to "YES" to enable freeswitch.
# Default is "NO".
# freeswitch_flags: Flags passed to freeswitch-script on startup.
# Default is "".
#
. /etc/rc.subr
name="freeswitch"
rcvar=${name}_enable
load_rc_config $name
: ${freeswitch_enable="NO"}
: ${freeswitch_pidfile="/usr/local/freeswitch/run/freeswitch.pid"}
start_cmd=${name}_start
stop_cmd=${name}_stop
pidfile=${freeswitch_pidfile}
freeswitch_start() {
/usr/local/freeswitch/bin/freeswitch ${freeswitch_flags}
echo -n "Starting FreeSWITCH: "
}
freeswitch_stop() {
/usr/local/freeswitch/bin/freeswitch -stop
}
run_rc_command "$1"
</pre></li>
</ul></li>
</ul>
<ul>
<li>Make the script executable:<br /><pre>
chmod +x /usr/local/etc/rc.d/freeswitch
</pre></li>
</ul>
<ul>
<li>Start and enable freeswitch to start at boot:<br /><pre>
echo 'freeswitch_enable="YES"' >> /etc/rc.conf
echo 'freeswitch_flags="-nc"' >> /etc/rc.conf
service freeswitch start
</pre>
<ul>
<li><strong>NOTE</strong>: If your Freeswitch server has a IP address and not behind a NAT router, add the <code>-nonat</code> parameter to the freeswitch_flags. This will disable NAT traversal feature of FreeSWITCH.</li>
</ul></li>
</ul>
<a name="Install-FusionPBX"></a>
<h2 >Install FusionPBX<a href="#Install-FusionPBX" class="wiki-anchor">¶</a></h2>
<ul>
<li>Install fusionpbx:<br /><pre>
portmaster www/fusionpbx
</pre>
<ul>
<li><strong>NOTE</strong>: Make sure to enable <strong>[X]PDOPGSQL</strong> while configuring fusionpbx.</li>
</ul></li>
</ul>
<a name="Install-Nginx"></a>
<h2 >Install Nginx<a href="#Install-Nginx" class="wiki-anchor">¶</a></h2>
<ul>
<li>Install Nginx<br /><pre>
pkg install nginx
</pre></li>
</ul>
<ul>
<li>Start and enable nginx at boot:<br /><pre>
echo 'nginx_enable="YES"' >> /etc/rc.conf
service nginx start
</pre></li>
</ul>
<ul>
<li>Create a configuration directory to make managing individual server blocks easier<br /><pre>
mkdir /usr/local/etc/nginx/conf.d
</pre></li>
</ul>
<ul>
<li>Edit the main nginx config file:<br /><pre>
vi /usr/local/etc/nginx/nginx.conf
</pre>
<ul>
<li>And strip down the config file and add the include statement at the end to make it easier to handle various server blocks:<br /><pre>
#user nobody;
worker_processes 1;
error_log /var/log/nginx-error.log;
events {
worker_connections 1024;
}
http {
include mime.types;
default_type application/octet-stream;
sendfile on;
#tcp_nopush on;
#keepalive_timeout 0;
keepalive_timeout 65;
#gzip on;
# Load config files from the /etc/nginx/conf.d directory
include /usr/local/etc/nginx/conf.d/*.conf;
}
</pre></li>
</ul></li>
</ul>
<ul>
<li>Now create a config for pbx.example.com:<br /><pre>
vi /usr/local/etc/nginc/conf.d/pbx.example.com.conf
</pre>
<ul>
<li>And add the following:<br /><pre>
server{
listen 80;
server_name pbx.example.com;
access_log /var/log/nginx-access.log;
error_log /var/log/nginx-error.log;
client_max_body_size 10M;
client_body_buffer_size 128k;
root /usr/local/www/fusionpbx;
location / {
root /usr/local/www/fusionpbx;
index index.php;
}
location ~ \.php$ {
fastcgi_pass unix:/var/run/php-fpm.sock;
fastcgi_index index.php;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
}
# Disable viewing .htaccess & .htpassword & .db
location ~ .htaccess {
deny all;
}
location ~ .htpassword {
deny all;
}
location ~^.+.(db)$ {
deny all;
}
}
</pre></li>
</ul></li>
</ul>
<ul>
<li>Change the freeswitch config file ownership to the www user:<br /><pre>
chown -R www:www /usr/local/freeswitch/conf
</pre></li>
</ul>
<ul>
<li>Change the fusionpbx files ownership to the www user:<br /><pre>
chown -R www:www /usr/local/www/fusionpbx
</pre></li>
</ul>
<a name="Configure-PHP"></a>
<h3 >Configure PHP<a href="#Configure-PHP" class="wiki-anchor">¶</a></h3>
<ul>
<li>Configure the default PHP settings<br /><pre>
cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
</pre></li>
</ul>
<ul>
<li>Edit the php-fpm config file:<br /><pre>
vi /usr/local/etc/php-fpm.conf
</pre>
<ul>
<li>Make the following changes:<br /><pre>
listen = /var/run/php-fpm.sock
listen.owner = www
listen.group = www
listen.mode = 0660
</pre></li>
</ul></li>
</ul>
<ul>
<li>Start and enable PHP-FPM at boot:<br /><pre>
echo 'php_fpm_enable="YES"' >> /etc/rc.conf
service php-fpm start
</pre></li>
</ul>
<a name="Setup-Database"></a>
<h2 >Setup Database<a href="#Setup-Database" class="wiki-anchor">¶</a></h2>
<p><strong>NOTE</strong>: This guide has an external postgresql server and does not cover setting up the server.</p>
<ul>
<li>Create the database and user:<br /><pre>
su postgres
createuser -s -e fusionpbxuser
createdb -O fusionpbxuser fusionpbxdb
psql -d fusionpbxdb -U fusionpbxuser
ALTER USER fusionpbxuser with PASSWORD 'SuperSecretPassword';
</pre></li>
</ul>
<ul>
<li>Then open <a class="external" href="http://pbx.example.com">http://pbx.example.com</a> in a web browser and finish the installation; make sure to select the <strong>postgresql</strong> database adapter.</li>
</ul>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="http://wiki.fusionpbx.com/index.php?title=FreeBSD_Install">http://wiki.fusionpbx.com/index.php?title=FreeBSD_Install</a></li>
<li><a class="external" href="https://freeswitch.org/confluence/display/FREESWITCH/FreeBSD">https://freeswitch.org/confluence/display/FREESWITCH/FreeBSD</a></li>
<li><a class="external" href="https://code.google.com/p/libyuv/wiki/GettingStarted">https://code.google.com/p/libyuv/wiki/GettingStarted</a></li>
</ul> Hardware Hacking - Bug #654 (Closed): Restoring A Bricked HP DV6700 Notebook BIOShttps://project.altservice.com/issues/6542015-09-02T20:41:24ZDaniel Curtistechsupport@altservice.com
<p>I recently updated my HP dv6700 laptop to Windows 7, and some time later I noticed a problem with the laptops performance that could be solved with a BIOS update. However, the BIOS update utility I downloaded from the HP support site was designed for Windows Vista, so running the update utility on my new Windows 7 drive rendered my laptop useless; screen backlight not coming on, no hard drive light activity, no display on the screen, etc. These are some notes on how I recovered my laptop.</p>
<p><strong>THE BIOS CANNOT BE UPDATED WITH WINDOWS 7, IT MUST BE UPDATED USING WINDOWS VISTA.</strong></p>
<a name="Make-a-Recovery-USB-Disk"></a>
<h2 >Make a Recovery USB Disk<a href="#Make-a-Recovery-USB-Disk" class="wiki-anchor">¶</a></h2>
<ul>
<li>Download and install 7zip</li>
</ul>
<ul>
<li>First locate the BIOS for the specific laptop. This can be found at the HP support site.
<ul>
<li><strong>NOTE</strong>: I needed to use an older version of the BIOS firmware to get it working right.</li>
</ul></li>
</ul>
<ul>
<li>Right click on the spXXXXX.exe and use 7zip to extract it into a folder.</li>
</ul>
<ul>
<li>Download a copy of Crisdisk. I have a copy available for posterity.</li>
</ul>
<ul>
<li>Extract Crisdisk and open the folder Crisdisk was extracted to.</li>
</ul>
<ul>
<li>Copy the YYYYYYYY.WPH file into the directory where Crisdisk was extracted to.</li>
</ul>
<ul>
<li>Rename the YYYYYYYY.WPH file to <strong>BIOS.WPH</strong></li>
</ul>
<ul>
<li>Right click on the WINCRIS.EXE application and go to <ins>Properties -> Compatibility</ins>, and set the Compatibility Mode to <strong>Windows XP Service Pack 3</strong>.</li>
</ul>
<ul>
<li>Insert a USB drive that can be formatted.</li>
</ul>
<ul>
<li>Run the WINCRIS.EXE application</li>
</ul>
<ul>
<li>Once the WINCRIS applicaiton is open select the USB drive to use and click <strong>Start</strong></li>
</ul>
<ul>
<li>When the USB drive is finished formatting and setup, it can be removed without needing to eject it.</li>
</ul>
<a name="Reflash-the-BIOS"></a>
<h2 >Reflash the BIOS<a href="#Reflash-the-BIOS" class="wiki-anchor">¶</a></h2>
<ul>
<li>Unplug all cords, accessories, and the battery from the laptop.</li>
</ul>
<ul>
<li>Plug the laptop into AC power.</li>
</ul>
<ul>
<li>Take the USB drive and plug it into the laptop</li>
</ul>
<ul>
<li>Press and hold the <strong>Windows and B Keys</strong></li>
</ul>
<ul>
<li>While holding the Windows and B Keys, press the <strong>Power</strong> button.</li>
</ul>
<ul>
<li>The laptop will boot up and the USB drive should begin blinking and the laptop should beep.</li>
</ul>
<ul>
<li><ins>Wait for the laptop to power off by itself.</ins> This process should take around <strong>10 minutes</strong>.</li>
</ul>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="http://support.hp.com/us-en/drivers/selfservice/HP-Pavilion-dv6800-Entertainment-Notebook-PC-series/3672909/model/3708188#Z7_3054ICK0KGTE30AQO5O3KA30R1">http://support.hp.com/us-en/drivers/selfservice/HP-Pavilion-dv6800-Entertainment-Notebook-PC-series/3672909/model/3708188#Z7_3054ICK0KGTE30AQO5O3KA30R1</a></li>
<li><a class="external" href="http://h30434.www3.hp.com/t5/Notebook-Operating-Systems-and-Software/HP-Pavilion-laptop-dv7-bios-update-failed-Black-screen/td-p/341896/page/3">http://h30434.www3.hp.com/t5/Notebook-Operating-Systems-and-Software/HP-Pavilion-laptop-dv7-bios-update-failed-Black-screen/td-p/341896/page/3</a></li>
<li><a class="external" href="http://support.hp.com/us-en/document/c02693833">http://support.hp.com/us-en/document/c02693833</a></li>
<li><a class="external" href="http://h30434.www3.hp.com/t5/Notebook-Operating-Systems-and-Software/How-to-flash-BIOS-without-having-HP-Tools-Partition/td-p/533561">http://h30434.www3.hp.com/t5/Notebook-Operating-Systems-and-Software/How-to-flash-BIOS-without-having-HP-Tools-Partition/td-p/533561</a></li>
<li><a class="external" href="https://www.bios-mods.com/bios-recovery/phoenix-bios-recovery/">https://www.bios-mods.com/bios-recovery/phoenix-bios-recovery/</a></li>
<li><a class="external" href="https://gammarco.wordpress.com/2013/02/25/dead-hp-pavillion-dv6635el-after-last-bios-update-black-screen/">https://gammarco.wordpress.com/2013/02/25/dead-hp-pavillion-dv6635el-after-last-bios-update-black-screen/</a></li>
</ul> GNU/Linux Administration - Bug #634 (Closed): Problem With Postfix Receiving eMail From External ...https://project.altservice.com/issues/6342015-07-18T00:29:53ZDaniel Curtistechsupport@altservice.com
<p>I encountered a problem with iRedMail running postfix and it not being able to receive email from certain external mail servers.</p>
<p>The error I received from my email client (Thunderbird) said the following:<br /><pre>
----- Transcript of session follows -----
... while talking to mx1.example.com.:
>>> DATA
<<< 553 5.7.1 <user1@example.com>: Sender address rejected: not logged in
550 5.1.1 <user2@example.net>... User unknown
<<< 554 5.5.1 Error: no valid recipients
</pre></p>
<p>And the log file on the mail server stated:<br /><pre>
Jul 17 16:18:02 mx1 postfix/qmgr[60164]: F3E7A123A3A: from=<>, size=2865, nrcpt=1 (queue active)
Jul 17 16:18:02 mx1 postfix/cleanup[71309]: 06D04123A3B: message-id=<dovecot-1437175080-971579-0@mx1.example.com>
Jul 17 16:18:02 mx1 postfix/local[67463]: F3E7A123A3A: to=<root@mx1.example.com>, relay=local, delay=0.17, delays=0.15/0/0/0.02, dsn=2.0.0, status=sent (forwarded as 06D04123A3B)
Jul 17 16:18:02 mx1 postfix/qmgr[60164]: 06D04123A3B: from=<>, size=3003, nrcpt=1 (queue active)
Jul 17 16:18:02 mx1 amavis[68254]: (68254-13) Passed CLEAN {RelayedInternal}, LOCAL [127.0.0.1] <> -> <root@mx1.example.com>, Message-ID: <dovecot-1437175080-971579-0@mx1.example.com>, mail_id: vDpv6L-DvP3w, Hits: -0.001, size: 2382, queued_as: F3E7A123A3A, 836 ms
Jul 17 16:18:02 mx1 postfix/qmgr[60164]: F3E7A123A3A: removed
Jul 17 16:18:02 mx1 postfix/smtp[70981]: 1273F123A2C: to=<root@mx1.example.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.1, delays=0.19/0/0.01/0.86, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as F3E7A123A3A)
Jul 17 16:18:02 mx1 postfix/qmgr[60164]: 1273F123A2C: removed
Jul 17 16:18:02 mx1 postfix/pipe[64826]: 06D04123A3B: to=<postmaster@example.com>, relay=dovecot, delay=0.12, delays=0.02/0/0/0.1, dsn=2.0.0, status=sent (delivered via dovecot service)
Jul 17 16:18:02 mx1 postfix/qmgr[60164]: 06D04123A3B: removed
Jul 17 16:19:00 mx1 postfix/pickup[70686]: 6AC3A123A3E: uid=0 from=<root>
Jul 17 16:19:00 mx1 postfix/cleanup[71309]: 6AC3A123A3E: message-id=<20150717231900.6AC3A123A3E@mx1.example.com>
Jul 17 16:19:00 mx1 postfix/qmgr[60164]: 6AC3A123A3E: from=<root@mx1.example.com>, size=540, nrcpt=1 (queue active)
Jul 17 16:19:00 mx1 postfix/smtpd[68755]: connect from mx1.example.com[127.0.0.1]
Jul 17 16:19:00 mx1 postfix/smtpd[68755]: E67F1123A44: client=mx1.example.com[127.0.0.1]
Jul 17 16:19:00 mx1 postfix/cleanup[71309]: E67F1123A44: message-id=<20150717231900.6AC3A123A3E@mx1.example.com>
Jul 17 16:19:00 mx1 postfix/smtpd[68755]: disconnect from mx1.example.com[127.0.0.1]
Jul 17 16:19:00 mx1 postfix/qmgr[60164]: E67F1123A44: from=<root@mx1.example.com>, size=1023, nrcpt=1 (queue active)
Jul 17 16:19:00 mx1 postfix/cleanup[71309]: EA8FE123A45: message-id=<20150717231900.6AC3A123A3E@mx1.example.com>
Jul 17 16:19:00 mx1 postfix/local[67463]: E67F1123A44: to=<root@mx1.example.com>, relay=local, delay=0.08, delays=0.06/0/0/0.02, dsn=2.0.0, status=sent (forwarded as EA8FE123A45)
Jul 17 16:19:00 mx1 postfix/qmgr[60164]: EA8FE123A45: from=<root@mx1.example.com>, size=1161, nrcpt=1 (queue active)
Jul 17 16:19:00 mx1 postfix/qmgr[60164]: E67F1123A44: removed
Jul 17 16:19:00 mx1 amavis[66590]: (66590-19) Passed CLEAN {RelayedInternal}, MYUSERS LOCAL [127.0.0.1] <root@mx1.example.com> -> <root@mx1.example.com>, Message-ID: <20150717231900.6AC3A123A3E@mx1.example.com>, mail_id: wRldy-mpdjOD, Hits: -0.001, size: 540, queued_as: E67F1123A44, 512 ms
Jul 17 16:19:00 mx1 postfix/smtp[70677]: 6AC3A123A3E: to=<root@mx1.example.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.58, delays=0.04/0/0.01/0.53, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as E67F1123A44)
Jul 17 16:19:00 mx1 postfix/qmgr[60164]: 6AC3A123A3E: removed
Jul 17 16:19:01 mx1 postfix/pickup[70686]: 3F350123A49: uid=2000 from=<>
Jul 17 16:19:01 mx1 postfix/pipe[68637]: EA8FE123A45: to=<postmaster@example.com>, relay=dovecot, delay=0.3, delays=0.01/0/0/0.29, dsn=2.0.0, status=sent (delivered via dovecot service)
Jul 17 16:19:01 mx1 postfix/qmgr[60164]: EA8FE123A45: removed
Jul 17 16:19:01 mx1 postfix/cleanup[71309]: 3F350123A49: message-id=<dovecot-1437175141-40596-0@mx1.example.com>
Jul 17 16:19:01 mx1 postfix/qmgr[60164]: 3F350123A49: from=<>, size=2381, nrcpt=1 (queue active)
Jul 17 16:19:01 mx1 postfix/smtpd[68652]: connect from mx1.example.com[127.0.0.1]
Jul 17 16:19:02 mx1 postfix/smtpd[68652]: 00472123A5A: client=mx1.example.com[127.0.0.1]
Jul 17 16:19:02 mx1 postfix/cleanup[71309]: 00472123A5A: message-id=<dovecot-1437175141-40596-0@mx1.example.com>
Jul 17 16:19:02 mx1 postfix/smtpd[68652]: disconnect from mx1.example.com[127.0.0.1]
Jul 17 16:19:02 mx1 postfix/qmgr[60164]: 00472123A5A: from=<>, size=2864, nrcpt=1 (queue active)
Jul 17 16:19:02 mx1 postfix/cleanup[71309]: 0655B123A5B: message-id=<dovecot-1437175141-40596-0@mx1.example.com>
Jul 17 16:19:02 mx1 postfix/local[67463]: 00472123A5A: to=<root@mx1.example.com>, relay=local, delay=0.1, delays=0.08/0/0/0.02, dsn=2.0.0, status=sent (forwarded as 0655B123A5B)
Jul 17 16:19:02 mx1 postfix/qmgr[60164]: 0655B123A5B: from=<>, size=3002, nrcpt=1 (queue active)
Jul 17 16:19:02 mx1 postfix/qmgr[60164]: 00472123A5A: removed
Jul 17 16:19:02 mx1 amavis[70493]: (70493-04) Passed CLEAN {RelayedInternal}, LOCAL [127.0.0.1] <> -> <root@mx1.example.com>, Message-ID: <dovecot-1437175141-40596-0@mx1.example.com>, mail_id: vVqpsCZDVVTd, Hits: -0.001, size: 2381, queued_as: 00472123A5A, 682 ms
Jul 17 16:19:02 mx1 postfix/smtp[70981]: 3F350123A49: to=<root@mx1.example.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.98, delays=0.27/0/0.01/0.7, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 00472123A5A)
Jul 17 16:19:02 mx1 postfix/qmgr[60164]: 3F350123A49: removed
Jul 17 16:19:02 mx1 postfix/pipe[64826]: 0655B123A5B: to=<postmaster@example.com>, relay=dovecot, delay=0.12, delays=0.01/0/0/0.1, dsn=2.0.0, status=sent (delivered via dovecot service)
Jul 17 16:19:02 mx1 postfix/qmgr[60164]: 0655B123A5B: removed
Jul 17 16:19:02 mx1 postfix/smtpd[71508]: connect from atl4mhob04.myregisteredsite.com[209.17.115.42]
Jul 17 16:19:03 mx1 postfix/smtpd[71508]: NOQUEUE: reject: RCPT from atl4mhob04.myregisteredsite.com[209.17.115.42]: 553 5.7.1 <user1@example.com>: Sender address rejected: not logged in; from=<user1@example.com> to=<user2@example.net> proto=ESMTP helo=<atl4mhob04.myregisteredsite.com>
Jul 17 16:19:04 mx1 postfix/smtpd[71508]: disconnect from atl4mhob04.myregisteredsite.com[209.17.115.42]
</pre></p>
<ul>
<li>The problem turned out that I needed to edit the postfix <code>main.cf</code> file:<br /><pre>
vi /usr/local/etc/postfix/main.cf
</pre>
<ul>
<li>And remove remove the <strong>reject_sender_login_mismatch</strong><br /><pre>
# Removed reject_sender_login_mismatch option
smtpd_sender_restrictions = reject_unknown_sender_domain, reject_non_fqdn_sender
, reject_unlisted_sender, permit_mynetworks, permit_sasl_authenticated
</pre></li>
</ul></li>
</ul>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="http://www.iredmail.org/forum/topic163-iredmail-support-sender-address-rejected-not-logged-in.html">http://www.iredmail.org/forum/topic163-iredmail-support-sender-address-rejected-not-logged-in.html</a></li>
</ul> Website Hosting - Bug #527 (Closed): Unable to Login to StartCom Control Panel With "ssl_error_un...https://project.altservice.com/issues/5272015-01-05T18:02:24ZDaniel Curtistechsupport@altservice.com
<p>While going to renew one of my SSL certificates, I came across an error that prevented me from logging into the StartCom Control Panel. The error stated:</p>
<blockquote>
<p>Secure Connection Failed<br />An error occurred during a connection to auth.startssl.com.<br />Peer does not recognize and trust the CA that issued your certificate.<br />(Error code: ssl_error_unknown_ca_alert)</p>
</blockquote>
<p>The browser I use to administer my StartCom account is Firefox 34, and after looking around online I found a workaround.</p>
<ul>
<li>Go to <ins>Preferences -> Advanced -> Certificates -> View Certificates -> Authorities</ins></li>
<li>Scroll down to the <strong>StartCom Certificate Authority</strong></li>
<li>Now <ins>Delete/Distrust</ins> every certificate that is marked <strong>Software Security Device</strong></li>
</ul>
<p>Doing this allowed me to once again log into the StartCom Control Panel. Although I do not like the prospect of manipulating certificate authorities in the browser, I understand that StartCom recently changed one or more of their certificates, which will undoubtedly cause problems.</p>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="https://forum.startcom.org/viewtopic.php?f=15&t=2522&start=0&st=0&sk=t&sd=a&sid=8e35c7ce6440a09fbf7e808e0444e579&view=print">https://forum.startcom.org/viewtopic.php?f=15&t=2522&start=0&st=0&sk=t&sd=a&sid=8e35c7ce6440a09fbf7e808e0444e579&view=print</a></li>
</ul> Public - Bug #465 (Closed): Problem With DIVA 8 and Reverting to Previous DIVA Versions https://project.altservice.com/issues/4652014-09-25T21:45:54ZDaniel Curtistechsupport@altservice.com
<p>I have encountered a problem during my initial testing of the new release of DIVA version 8. The software itself does not have an issue while running and collecting data from the connected cytometer, in this case an LSRII and upgrading from DIVA 5.0.3. However, after working with DIVA 8, I decided to go back to my previous version of DIVA 5.0.3 for a number of reasons outside the scope of this issue.</p>
The basic steps to reproduce this problem is:
<ol>
<li>Open DIVA 5.0.3 on the Windows XP workstation, to verify that the cytometer connection works.</li>
<li>Remove Windows XP and DIVA 5.0.3 workstation from the cytometer.</li>
<li>Replace the workstation with Windows 7 and install DIVA 8, connected to the cytometer.</li>
<li>Connect to the cytometer with DIVA 8, verifying the connection to the cytometer works.</li>
<li>Disconnect Windows 7 workstation from the cytometer.</li>
<li>Reconnect the Windows XP workstation to the cytometer.</li>
<li>Open DIVA 5.0.3 and connect to the cytometer.</li>
<li>Error is displayed, DIVA 5.0.3 cytometer connection is now broken.</li>
</ol>
<a name="The-Problem"></a>
<h2 >The Problem<a href="#The-Problem" class="wiki-anchor">¶</a></h2>
<ul>
<li>After removing the DIVA 8 workstation and then reconnecting the DIVA 5.0.3 workstation.</li>
</ul>
<ul>
<li>I then started my computer and the cytometer.</li>
</ul>
<ul>
<li>After the system was done loading, I turned on my cytometer and then loaded DIVA to receive an error from DIVA:<br /><pre>
ERROR: Bootup failed
-----> Unable to load module: host_192.168.2.1:\embedded\bootFiles\LSRII\bdfacs_csc.out errno=1835009
</pre></li>
</ul>
<a name="A-Not-So-Workaround"></a>
<h3 >A Not-So-Workaround<a href="#A-Not-So-Workaround" class="wiki-anchor">¶</a></h3>
<p>The above problem is a very serious one, in that now I am stuck with DIVA 8. Unless every time the older DIVA workstation is rebooted, DIVA will need to be reinstalled using the existing database. This is not a fix, but a poor workaround at the very best.</p>
<hr />
<a name="The-Potential-Source-of-the-Problem"></a>
<h2 >The Potential Source of the Problem<a href="#The-Potential-Source-of-the-Problem" class="wiki-anchor">¶</a></h2>
<p>I decided to uninstall DIVA again and open up HyperTerminal and create a connection to <strong>COM1</strong> using a standard <ins>9600-8-None-1</ins> serial configuration.</p>
<ul>
<li>I received the following debugging output from HyperTerminal while reinstalling DIVA 5.0.3 (since installing DIVA 8):<br /><pre>
Press any key to stop auto-boot...
0
auto-booting...
boot device : ata=0,0
unit number : 0
processor number : 0
file name : /ata0/vxWorks
inet on ethernet (e) : 192.168.1.1:ffff0000
host inet (h) : 192.168.2.1
user (u) : nextgen
ftp password (pw) : bdis
flags (f) : 0x8
target name (tn) : sc
other (o) : fei
Attaching to ATA disk device... done.
Loading /ata0/vxWorks...1134632 + 43984 + 40780
Starting at 0x408000...
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]] ]]]] ]]]]]]]]]] ]] ]]]] (R)
] ]]]]]]]]] ]]]]]] ]]]]]]]] ]] ]]]]
]] ]]]]]]] ]]]]]]]] ]]]]]] ] ]] ]]]]
]]] ]]]]] ] ]]] ] ]]]] ]]] ]]]]]]]]] ]]]] ]] ]]]] ]] ]]]]]
]]]] ]]] ]] ] ]]] ]] ]]]]] ]]]]]] ]] ]]]]]]] ]]]] ]] ]]]]
]]]]] ] ]]]] ]]]]] ]]]]]]]] ]]]] ]] ]]]] ]]]]]]] ]]]]
]]]]]] ]]]]] ]]]]]] ] ]]]]] ]]]] ]] ]]]] ]]]]]]]] ]]]]
]]]]]]] ]]]]] ] ]]]]]] ] ]]] ]]]] ]] ]]]] ]]]] ]]]] ]]]]
]]]]]]]] ]]]]] ]]] ]]]]]]] ] ]]]]]]] ]]]] ]]]] ]]]] ]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]] Development System
]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]] VxWorks version 5.4
]]]]]]]]]]]]]]]]]]]]]]]]]] KERNEL: WIND version 2.5
]]]]]]]]]]]]]]]]]]]]]]]]] Copyright Wind River Systems, Inc., 1984-1999
CPU: Radisys EPC-16. Processor #0.
Memory Size: 0x3fff000. BSP version 1.2/0.
WDB: Ready.
VxWorks Version:
-> @Version@Jul 2 2013 02:20:38,ALL,VxWorks Boot Server,v6.0@
Cytometer IP Address: 192.168.1.1
STATUS: Host connecting to instrument boot socket from 192.168.2.1
Cytometer IP Address: 192.168.1.1
Instrument Type: LSRII
Currently loaded VxWorks version:
@Version@Jul 2 2013 02:20:38,ALL,VxWorks Boot Server,v6.0@
Attempting to download VxWorks version:
@Version@Aug 22 2007 11:10:25,ALL,VxWorks Boot Server,v5.0@
VxWorks update not required
</pre></li>
</ul>
<p>The above debugging output shows that the current VxWorks Boot Server is version 6.0</p>
<ul>
<li>And the following is debugging output from Hyperterminal, after installing DIVA 5.0.3 and rebooting the machine:<br /><pre>
VxWorks System Boot
Copyright 1984-1998 Wind River Systems, Inc.
CPU: Radisys EPC-16
Version: 5.4
BSP version: 1.2/0
Creation date: Feb 8 2001, 12:45:56
Press any key to stop auto-boot...
0
auto-booting...
boot device : ata=0,0
unit number : 0
processor number : 0
file name : /ata0/vxWorks
inet on ethernet (e) : 192.168.1.1:ffff0000
host inet (h) : 192.168.2.1
user (u) : nextgen
ftp password (pw) : bdis
flags (f) : 0x8
target name (tn) : sc
other (o) : fei
Attaching to ATA disk device... done.
Loading /ata0/vxWorks...1134632 + 43984 + 40780
Starting at 0x408000...
Attached TCP/IP interface to fei unit 0
Attaching interface lo0...done
Loading symbol table from /ata0/vxWorks.sym ...done
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]] ]]]] ]]I can confirm that this does work]]]]]]]] ]] ]]]] (R)
] ]]]]]]]]] ]]]]]] ]]]]]]]] ]] ]]]]
]] ]]]]]]] ]]]]]]]] ]]]]]] ] ]] ]]]]
]]] ]]]]] ] ]]] ] ]]]] ]]] ]]]]]]]]] ]]]] ]] ]]]] ]] ]]]]]
]]]] ]]] ]] ] ]]] ]] ]]]]] ]]]]]] ]] ]]]]]]] ]]]] ]] ]]]]
]]]]] ] ]]]] ]]]]] ]]]]]]]] ]]]] ]] ]]]] ]]]]]]] ]]]]
]]]]]] ]]]]] ]]]]]] ] ]]]]] ]]]] ]] ]]]] ]]]]]]]] ]]]]
]]]]]]] ]]]]] ] ]]]]]] ] ]]] ]]]] ]] ]]]] ]]]] ]]]] ]]]]
]]]]]]]] ]]]]] ]]] ]]]]]]] ] ]]]]]]] ]]]] ]]]] ]]]] ]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]]]] Development System
]]]]]]]]]]]]]]]]]]]]]]]]]]]]
]]]]]]]]]]]]]]]]]]]]]]]]]]] VxWorks version 5.4
]]]]]]]]]]]]]]]]]]]]]]]]]] KERNEL: WIND version 2.5
]]]]]]]]]]]]]]]]]]]]]]]]] Copyright Wind River Systems, Inc., 1984-1999
CPU: Radisys EPC-16. Processor #0.
Memory Size: 0x3fff000. BSP version 1.2/0.
WDB: Ready.
VxWorks Version:
-> @Version@Jul 2 2013 02:20:38,ALL,VxWorks Boot Server,v6.0@
Cytometer IP Address: 192.168.1.1
STATUS: Host connecting to instrument boot socket from 192.168.2.1
undefined symbol: _getCscConfiguration__Fv
ERROR: Bootup failed
-----> Unable to load module: host_192.168.2.1:\embedded\bootFiles\LSRII\bdfacs_
csc.out errno=1835009
</pre></li>
</ul>
<a name="Another-Not-So-Workaround"></a>
<h3 >Another Not-So-Workaround<a href="#Another-Not-So-Workaround" class="wiki-anchor">¶</a></h3>
<p>The technical support at BD suggest that it may be possible to take the SSD hard drive from that is connected to the Radisys control board inside the cytometer and swap it with another SSD hard drive from another Radisys control board from a cytometer that has not yet been upgraded by DIVA 8.</p>
<strong><ins>I can confirm that this does work.</ins></strong> However, there are a few things that need to be considered:
<ol>
<li>This is not a fix, but another poor workaround, since the DIVA 8 upgraded SSD hard drive from the Radisys board still needs to be connected to a DIVA 8 machine and I am wanting to go back to a previous version of DIVA. </li>
<li>A high technical proficiency is required to remove the SSD hard drive from the Radisys board, this is due to the mount bracket that holds the SSD hard drive needs to be slid out of its socket and if not done carefully will break delicate circuit components, this rendering the whole Radisys board useless.</li>
<li>When replacing the SSD hard drive, make sure to match the drive that will be swapped with the cytometer being used: example, if replacing an SSD hard drive for an LSRII Radisys, make sure to swap it with an SSD hard drive from an LSRII.</li>
</ol>
<p>Automation Laboratory Technology provides a service that can correct this problem.</p> Automation Laboratory Technology - Support #449 (Closed): Internal Audit Procedure for ALThttps://project.altservice.com/issues/4492014-09-01T20:24:27ZDaniel Curtistechsupport@altservice.com
<ul class="toc right"><li><strong>Table of contents</strong></li><li><a href="#Phase-1-Gathering-All-Financial-Information">Phase 1: Gathering All Financial Information</a><ul><li><a href="#Phase-1-Wrap-Up">Phase 1 - Wrap Up</a></li></ul>
</li><li><a href="#Phase-2-Categorize-Financial-Information">Phase 2: Categorize Financial Information</a><ul><li><ul><li><a href="#Discrepancies-can-take-many-forms-such-as-but-not-limited-to">Discrepancies can take many forms; such as, but not limited to:</a></li></ul>
</li><li><a href="#Income">Income</a></li><li><a href="#Expense">Expense</a></li><li><a href="#Phase-2-Wrap-Up">Phase 2 - Wrap Up</a></li></ul>
</li><li><a href="#Phase-3-Correlate-Financial-Information">Phase 3: Correlate Financial Information</a><ul><li><a href="#Correlating-Business-Income">Correlating Business Income</a></li><li><a href="#Correlating-Cost-of-Goods-Sold">Correlating Cost of Goods Sold</a></li><li><a href="#Correlating-Other-Income">Correlating Other Income</a></li><li><a href="#Correlating-Business-Expenses">Correlating Business Expenses</a></li><li><a href="#Phase-3-Wrap-Up">Phase 3 - Wrap Up</a></li></ul>
</li><li><a href="#Phase-4-Putting-It-All-Together">Phase 4: Putting It All Together</a><ul><li><a href="#Putting-together-the-Tax-Filing-Bundle">Putting together the Tax Filing Bundle</a><ul><li><a href="#Finding-the-relevant-Forms-Instructions-and-Publications">Finding the relevant Forms, Instructions, and Publications</a></li><li><a href="#Creating-a-Blank-Tax-Filing-Bundle">Creating a Blank Tax Filing Bundle</a></li><li><a href="#Creating-a-Complete-Tax-Filing-Bundle">Creating a Complete Tax Filing Bundle</a></li><li><a href="#Starting-with-the-Form-1040-Schedule-C">Starting with the Form 1040 Schedule C</a></li><li><a href="#Optional-Form-4562">(Optional) Form 4562</a></li><li><a href="#Optional-Form-8829">(Optional) Form 8829</a></li><li><a href="#Moving-on-with-Form-1040-Schedule-SE">Moving on with Form 1040 Schedule SE</a></li><li><a href="#Beginning-Form-1040">Beginning Form 1040</a></li><li><a href="#Completing-Form-1040-Schedule-A">Completing Form 1040 Schedule A</a></li><li><a href="#Finishing-Form-1040">Finishing Form 1040</a></li></ul>
</li><li><a href="#Putting-together-the-Financial-Record-Bundle">Putting together the Financial Record Bundle</a></li></ul>
</li><li><a href="#Resources">Resources</a></li></ul>
<p>This is a guide for the basic financial auditing procedure for Automation Laboratory Technology. The purpose of this guide is to gather and verify each monetary business transaction, correlate each transaction to validate its legitimacy, sort each validated transaction into a proper tax category, provide a realistic representation of all financial business transactions for both income and expenses. The goal of this guide is to create an organized <strong><ins>Financial Record Bundle</ins></strong> and an accompanying <strong><ins>Tax Filing Bundle</ins></strong>; these two things, when accurately organized, will be sufficient for an IRS audit.</p>
The finished product will be:
<ol>
<li><strong><ins>Financial Record Bundle</ins></strong>: This is an organized bundle of <strong>Bank Statements</strong>, <strong>Physical Check Stubs</strong>, <strong>Any Relevant QuickBooks Reports</strong>, <strong>Physical Receipts</strong>, <strong>Invoices</strong>, <strong>Expense Reports/Statements</strong>, <strong>Logs</strong>, <strong>Notes</strong>, etc.</li>
<li><strong><ins>Tax Filing Bundle</ins></strong>: This is a completed <strong>Form 1040 Income Tax Return</strong> with all relevant <strong>Forms</strong> attached.</li>
</ol>
<a name="Phase-1-Gathering-All-Financial-Information"></a>
<h1 >Phase 1: Gathering All Financial Information<a href="#Phase-1-Gathering-All-Financial-Information" class="wiki-anchor">¶</a></h1>
<p>This phase is where all relevant financial information is gathered. Information should include:</p>
<ol>
<li><strong>Bank Statements</strong>: Checking and Savings accounts; for <strong>income</strong> verification.</li>
<li><strong>Credit Card Statements</strong>: Business and Expense accounts; for <strong>expense</strong> verification.</li>
<li><strong>PayPal Transactions</strong>: Download a full transaction sheet from <a class="external" href="https://history.paypal.com">https://history.paypal.com</a> (you may need to login first); for <strong>income</strong> verification</li>
<li><strong>Employee/Contractor 1099's</strong>: 1099 Statements of an Employee/Contractor sent to the IRS; for <strong>expense</strong> verification.</li>
<li><strong>Customer 1099's</strong>: 1099 Statements from customers at the End of Year: for <strong>income</strong> verification.</li>
<li><strong>QuickBooks Detailed Income Tax Report</strong>: Invoiced Amounts; for <strong>income</strong> verification.</li>
<li><strong>QuickBooks Simple Profit & Loss Report</strong>: General overview of income and expenses; for <strong>income/expense</strong> verification</li>
<li><strong>Physical Check Stubs</strong>: Stubs from payments; for <strong>income</strong> verification.</li>
<li><strong>Physical Invoices</strong>: Paper invoice documents; for <strong>income</strong> verification</li>
<li><strong>Expense Reports & Statements</strong>: Expense reports and statements provided by Employee/Contractor; for <strong>expense</strong> verification.</li>
<li><strong>Physical Receipts</strong>: Physical receipts from business purchases; for <strong>expense</strong> verification.</li>
<li><strong>Vehicle Expense Receipts</strong>: Physical receipts from Fuel, Maintenance, Repairs, etc.; for <strong>expense</strong> verification.</li>
</ol>
<p><strong>NOTE</strong>: To be as accurate as possible, all of the above requirements must be met. It is OK if a couple of requirements are missing, however it will increase the difficulty in reconstructing the financial history.</p>
<a name="Phase-1-Wrap-Up"></a>
<h2 >Phase 1 - Wrap Up<a href="#Phase-1-Wrap-Up" class="wiki-anchor">¶</a></h2>
<p>At this point, as much as the above financial information. To make the next phase easier an abundant supply of paper clips, staples, pens, sticky notes, and paper envelope. Preparing labeled paper envelopes for each tax category will make it easier to categorize each receipt, statement, and/or report.</p>
<hr />
<a name="Phase-2-Categorize-Financial-Information"></a>
<h1 >Phase 2: Categorize Financial Information<a href="#Phase-2-Categorize-Financial-Information" class="wiki-anchor">¶</a></h1>
<p>This phase is where all the gathered information from the previous phase be categorized into one of two groups, <strong>Income</strong> or <strong>Expense</strong>, and then further categorized into one of the IRS tax categories.</p>
<p>Physical business receipts and monetary transactions for services and products used during the course of doing business are divided into envelopes for each tax category; each envelope being labeled with <strong>Tax Category Name</strong>, <strong>Category Form Line</strong>, <strong>Category Total Amount</strong>, and <strong>Attached Ticker Tape of Total</strong>.</p>
<p><strong>NOTE</strong>: Any discrepancy must be noted and reconciled for an accurate tax filing.</p>
<a name="Discrepancies-can-take-many-forms-such-as-but-not-limited-to"></a>
<h3 >Discrepancies can take many forms; such as, but not limited to:<a href="#Discrepancies-can-take-many-forms-such-as-but-not-limited-to" class="wiki-anchor">¶</a></h3>
<ol>
<li>"A check stub from a check for a repayment of a loan" </li>
<li>"A missing check stub for deposit record" </li>
<li>"An invoice issued in one year, but remitted in a following year" </li>
<li>"An invoice issued and payment received that were not paired together, resulting in duplicated income amounts" </li>
<li>"A payment received from an invoice issued in a previous year" </li>
<li>"An expense report/statement being lazily written off as Contract Labor, instead of being sorted into the proper Business Expense Tax Categories" </li>
<li>"Incomplete 1040 Bundle, missing Forms that do not efficiently maximize deductions" </li>
<li>"Not adding up the Sales Tax from Physical Physical Receipts or Business Physical Receipts Missing a Categorization" </li>
<li>"Not claiming a special Tax Credit that may be eligible for the year being audited" </li>
<li>"Not claiming any special Tax Payments, Regulations, Forms that may be eligible for the year being audited"</li>
</ol>
<p><strong>NOTE</strong>: For updates and/or special tax information, refer to the proper Instructional Documents for each <em>Form</em> in the <strong><ins>Tax Filing Bundle</ins></strong>, as well as their related Publications.</p>
<a name="Income"></a>
<h2 >Income<a href="#Income" class="wiki-anchor">¶</a></h2>
<p>This group involves all monetary transactions coming into the business bank accounts, as well as transactions that adjust the overall <strong><em>Gross Income</em></strong>:</p>
<ul>
<li><strong>Gross Receipts or Sales</strong>: This is the total amount invoiced out to customers during the year being audited, including amounts written as <strong><ins>Allowances</ins></strong>; This is for <em><ins>Line 1 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Allowances</strong>: This is the amount invoiced to a customer, but written off as an <strong><ins>Allowance</ins></strong>, such as a sample or donation service; This is for <em><ins>Line 2 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Cost of Goods Sold</strong>: This is actually an expense, but is needed to achieve a <em>Billable Sale</em>, this is for <em><ins>Line 4 of Form 1040 Schedule C</ins></em> and is a total of things like:
<ul>
<li><em>Materials</em>: These are things necessary for a product or service to be accomplished; This is for <em><ins>Line 38 of Form 1040 Schedule C</ins></em>.</li>
<li><em>Shipping Expenses</em>: This necessary to ship a product; This is for <em><ins>Line 39 of Form 1040 Schedule C</ins></em>.</li>
</ul></li>
</ul>
<ul>
<li><strong>Other Income</strong>: These are things such as interest gathered in a savings account; This is for <em><ins>Line 6 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<a name="Expense"></a>
<h2 >Expense<a href="#Expense" class="wiki-anchor">¶</a></h2>
<ul>
<li><strong>Advertising</strong>: These are expenses that promote and/or advertise business, such as door prizes, business retreats, etc.; This is for <em><ins>Line 8 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Vehicle Expenses</strong>: These are expenses of business vehicles, such as fuel, repairs, tires, car washes, etc.; This is for <em><ins>Line 9 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Commissions and Fees</strong>: These are expenses such as ATM and banking fees during business transactions; This is for <em><ins>Line 10 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Contract Labor</strong>: These are expenses paid to contractors for services and/or labor; This is for <em><ins>Line 11 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Depletion</strong>: These are not used by ALT, but referenced for potential use; This is for <em><ins>Line 12 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Depreciation</strong>: These are the total values of long-term depreciable items, such as real property, vehicles, equipment, etc.; This is for <em><ins>Line 13 of Form 1040 Schedule C</ins></em>. <strong>Requires Form 4562</strong>.</li>
</ul>
<ul>
<li><strong>Employee Benefit Programs</strong>: These are not used by ALT, but referenced for potential use; This is for <em><ins>Line 14 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Insurance</strong>: These are expenses from insurance (not health); This is for <em><ins>Line 15 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong><ins>Interest</ins></strong>
<ul>
<li><strong>Mortgage</strong>: These are expenses from mortgage interest paid to banks for things such as real property; This is for <em><ins>Line 16a of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Other</strong>: These are expenses from interest paid for things such as loans; This is for <em><ins>Line 16b of Form 1040 Schedule C</ins></em>.</li>
</ul></li>
</ul>
<ul>
<li><strong>Legal and Professional Services</strong>: These are expanses from lawyer, accountant, or other professional services used by the business; This is for <em><ins>Line 17 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Office Expenses</strong>: These are expenses that are for business operations to function, such as furniture, desks, computers, software, etc.; This is for <em><ins>Line 18 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Pension or Profit-Sharing Plans</strong>: These are not used by ALT, but are referenced for potential use; This is for <em><ins>Line 19 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong><ins>Rent or Lease</ins></strong>
<ul>
<li><strong>Vehicles, machinery, and equipment</strong>: These are expenses for vehicle and equipment rentals, such as land-moving equipment, rental skis during a business retreat/product research, etc.; This is for <em><ins>Line 20a of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Other business property</strong>: These are expenses for other business property, such as office space; This is for <em><ins>Line 20b of Form 1040 Schedule C</ins></em>.</li>
</ul></li>
</ul>
<ul>
<li><strong>Repairs and Maintenance</strong>: These are expenses for repairs and maintenance of business property; This is for <em><ins>Line 21 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Supplies</strong>: These are expenses for supplies needed to create, modify, or combine to make products for sale or service; This is for <em><ins>Line 22 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Taxes and Licenses</strong>: These are expenses from taxes or licenses paid for business transactions; This is for <em><ins>Line 23 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong><ins>Travel, Meals, and Entertainment</ins></strong>
<ul>
<li><strong>Travel</strong>: These are expenses from traveling to/from customers or business related tasks; This is for <em><ins>Line 24a of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Meals and Entertainment</strong>: These are expenses from meal, entertainment, or gifts to customers or business related peers; This is for <em><ins>Line 24b of Form 1040 Schedule C</ins></em>.</li>
</ul></li>
</ul>
<ul>
<li><strong>Utilities</strong>: These are expenses from daily resources used for business operations, such as water, electricity, waste, Internet, telephones, fax, etc.; This is for <em><ins>Line 25 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Wages</strong>: These are not used by ALT, but reference for potential use; This is for <em><ins>Line 26 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong><ins>Other Expenses</ins></strong>: This is for <em><ins>Line 27 of Form 1040 Schedule C</ins></em>.
<ul>
<li><strong>Product Research & Development</strong>: These are expenses for materials used for product research and development; This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Dues & Subscriptions</strong>: These are expenses for dues and subscriptions to service research and learning; This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Executive Dining Area</strong>: These are expenses for food and catering during company meetings, interviews, overtime, and/or holiday celebration; This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>.</li>
</ul></li>
</ul>
<ul>
<li><strong>Total Expenses</strong>: This is the gross total of business expenses, which is added from the all the above <ins>Expense</ins> categories; this is for <em><ins>Line 28 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<ul>
<li><strong>Expenses for Business Use of Home</strong>: This is for writing off a portion of a personal home for business use, such as storage space or a home office; this is for <em><ins>Line 30 of Form 1040 Schedule C</ins></em>. <strong>Requires Form 8829</strong></li>
</ul>
<p><strong>NOTE</strong>: For more information about <ins>Business Expenses</ins>, refer to <em>Publication 535</em>.</p>
<a name="Phase-2-Wrap-Up"></a>
<h2 >Phase 2 - Wrap Up<a href="#Phase-2-Wrap-Up" class="wiki-anchor">¶</a></h2>
<p>At this point every receipt, statement, report, invoice, and financial business transaction has been identified and organized into paper envelopes that are labeled with the appropriate tax category name, category form line number, category total, attached ticker tape of total. To make the next phase easier print out QuickBooks Detail Reports for each relevant expense account, this will make matching receipts easier. Blue, red, and black pens will help with a marking scheme; using check marks, X's, dots, circles, etc. Just make sure note on the paper what each symbol means, this makes correlation much less tedious. Also, sort and organize each of the envelopes in a small plastic container, this isn't necessary but it makes organizing easier. And one more thing, rest; the next phase will require a great deal of patience and focus, so get a good night sleep and spend as much time as necessary to complete the next phase.</p>
<hr />
<a name="Phase-3-Correlate-Financial-Information"></a>
<h1 ><strong>Phase 3</strong>: Correlate Financial Information<a href="#Phase-3-Correlate-Financial-Information" class="wiki-anchor">¶</a></h1>
<p>This is where the real auditing takes place, and requires a great deal of patience and attention to detail.</p>
<a name="Correlating-Business-Income"></a>
<h2 >Correlating Business Income<a href="#Correlating-Business-Income" class="wiki-anchor">¶</a></h2>
<blockquote>
<p><em>[Invoice Numbers (<strong>QB Tax Report</strong>)]</em> --> <em>[Physical Invoices]</em> --> <strong>QuickBooks Tax Report</strong> --> <em>[Total Invoiced]</em> --> <strong><ins>Allowances</ins></strong> --> <em>[Bank Statements]</em> --> <em>[Check Stubs]</em> --> <em>[Total Deposited]</em> --> <em>[Invoice Number]</em> --> <strong>QuickBooks Tax Report</strong> --> <strong><ins>Gross Receipts or Sales</ins></strong></p>
</blockquote>
The main process for verifying <strong><ins>Gross Receipts or Sales</ins></strong> for <em><ins>Form 1040 Schedule C Line 1</ins></em> is simple:
<ol>
<li>Find the <em>[Invoice Numbers]</em> from the <strong>QuickBooks Tax Report</strong> for every invoice for the year being audited; taking note of every invoice number. </li>
<li>Add up the <em>[Total Invoiced]</em> for the year being audited using the <em>[Physical Invoices]</em>, including <strong><ins>Allowances</ins></strong> (they will be subtracted later), <strong>Ticker Tape this Total</strong> for later correlation; correlate with the <strong>QuickBooks Income Tax Report</strong> and taking note of any discrepancy.</li>
<li>Add up the <strong><em>Total Allowances</em></strong> for the year being audited using the <em>[Physical Invoices]</em>, <strong>Ticker Tape this Total</strong> for later correlation; correlate with the <strong>QuickBooks Tax Report+</strong> and taking note of any discrepancy; if no discrepancies are found use this should represent an adequate figure for <strong><ins>Allowances</ins></strong> for <em><ins>Form 1040 Schedule C Line 2</ins></em>.</li>
<li>Add up the <em>[Total Deposited]</em> for the year being audited using <em>[Bank Statements]</em>, <strong>Ticker Tape this Total</strong> making sure to not include deposits from other business accounts, such as savings; correlate each deposited amount with <strong><ins>Invoice Number</ins></strong> and <strong><ins>Check Stub</ins></strong> and taking note of any discrepancy.</li>
<li>Correlate the <em>[Total Deposited]</em> with the <strong>QuickBooks Tax Report</strong>, taking note of any discrepancy. </li>
<li>At this point any income discrepancies should be spotted, noted, and reconciled; once every discrepancy has been reconciled the <strong><em>Total Invoiced</em></strong> should represent an adequate figure for <strong><ins>Gross Receipts or Sales</ins></strong> for <em><ins>Form 1040 Schedule C Line 1</ins></em>.</li>
</ol>
By now you should have:
<ol>
<li><ins>Gross Receipts or Sales</ins>* for <em><ins>Form 1040 Schedule C Line 1</ins></em></li>
<li><ins>Allowances</ins>* for <em><ins>Form 1040 Schedule C Line 2</ins></em></li>
</ol>
<a name="Correlating-Cost-of-Goods-Sold"></a>
<h2 >Correlating Cost of Goods Sold<a href="#Correlating-Cost-of-Goods-Sold" class="wiki-anchor">¶</a></h2>
<blockquote>
<p><em>[Materials Physical Receipts]</em> --> <strong>QuickBooks Materials Report</strong> --> <strong><ins>Materials</ins></strong> --> <em>[Shipping Expense Physical Receipts]</em> --> <strong>QuickBooks Shipping Expense Report</strong> --> <strong><ins>Shipping Expense</ins></strong> --> <strong><ins>Cost of Goods Sold</ins></strong></p>
</blockquote>
The main process for verifying <strong><ins>Cost of Goods Sold</ins></strong> for <em><ins>Form 1040 Schedule C Line 4</ins></em> is simple:
<ol>
<li>Correlate <em>[Materials]</em> and <em>[Shipping Expense Physical Receipts]</em> with the <strong>QuickBooks Detailed Materials Report</strong> and <strong>QuickBooks Detailed Shipping Expense Report</strong>, respectively; for each <em>[Physical Receipt]</em> not found in the <strong>QuickBooks Reports</strong> set apart set apart to be added to the total. </li>
<li>Add up <strong>QuickBooks Detailed Materials Report Total</strong> with any <strong><ins>Physical Receipts</ins></strong> not included on the report, this will be the the total for <strong><ins>Materials</ins></strong> for <em><ins>Line 38 of Form 1040 Schedule C</ins></em>.</li>
<li>Add up <strong>QuickBooks Detailed Shipping Expense Report Total</strong> with any <strong><ins>Physical Receipts</ins></strong> not included on the report, this will be the the total for <strong><ins>Shipping Expenses</ins></strong> for <em><ins>Line 39 of Form 1040 Schedule C</ins></em>.</li>
<li>Once all the above have been verified and reconciled. add up both <strong><ins>Materials</ins></strong> and <ins>Shipping Expenses</ins>* to come up with <strong><ins>Cost of Goods Sold</ins></strong> for <em><ins>Form 1040 Schedule C Line 4</ins></em>.</li>
</ol>
By now you should have:
<ol>
<li><ins>Cost of Goods Sold</ins>* for <em><ins>Form 1040 Schedule C Line 4</ins></em></li>
<li><ins>Materials</ins>* for <em><ins>Line 38 of Form 1040 Schedule C</ins></em></li>
<li><ins>Shipping Expenses</ins>* for <em><ins>Line 39 of Form 1040 Schedule C</ins></em></li>
</ol>
<a name="Correlating-Other-Income"></a>
<h2 >Correlating Other Income<a href="#Correlating-Other-Income" class="wiki-anchor">¶</a></h2>
<blockquote>
<p><em>[Interest Dividend (<strong>Bank Statements</strong>)]</em> --> <strong>QuickBooks Other Income Report</strong> --> <strong><ins>Other Income</ins></strong></p>
</blockquote>
The main process for verifying <strong><ins>Other Income</ins></strong> for <em><ins>Form 1040 Schedule C Line 6</ins></em> is simple:
<ol>
<li>Add up the <em>[Interest Dividends]</em> for the year auditing using <strong>Bank Statements</strong>, <strong>Ticker Tape this Total</strong>.</li>
<li>Correlate the <em>[Interest Dividends]</em> with the <strong><ins>QuickBooks Other Income Detail Report</ins></strong>, taking note of any discrepancy. </li>
<li>Once the <strong>Interest Dividends</strong> have been verified and reconciled, add up the total to come up with <strong><ins>Other Income</ins></strong>, for <em><ins>Line 6 of Form 1040 Schedule C</ins></em>.</li>
</ol>
By now you should have:
<ol>
<li><ins>Other Income</ins>* for <em><ins>Line 6 of Form 1040 Schedule C</ins></em></li>
</ol>
<a name="Correlating-Business-Expenses"></a>
<h2 >Correlating Business Expenses<a href="#Correlating-Business-Expenses" class="wiki-anchor">¶</a></h2>
<p>The main process for verifying <strong><ins>Total Business Expenses</ins></strong> <em><ins>Form 1040 Schedule C Line 28</ins></em> is a bit more involved than the Income section:</p>
<strong>QuickBooks Advertising and Promotions Report</strong> --> <em>[Advertising Receipts]</em> --> <strong><ins>Advertising</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Advertising and Promotions Report</strong> with the <em>[Advertising Receipts]</em>, setting aside any receipts that are not found in the QuickBook Report; add the total from the <em>[Advertising Receipts]</em> that were not found in the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Advertising</ins></strong> for <em><ins>Form 1040 Schedule C Line 8</ins></em>.</li>
</ul>
<strong>QuickBooks Total Automobile Report</strong> --> <em>[Vehicle Expense Receipts]</em> --> <strong><ins>Car and Truck Expenses</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Total Automobile Report</strong> with the <em>[Vehicle Expense Receipts]</em>, setting aside any receipts that are not listed in the QuickBook Report; add the total from the <em>[Vehicle Expense Receipts]</em> that were set aside with the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Car and Truck Expenses</ins></strong> for <em><ins>Form 1040 Schedule C Line 9</ins></em>.</li>
</ul>
<strong>QuickBooks Bank Fees Report</strong> --> <em>[Commissions and Fees Receipts]</em> --> <strong><ins>Commissions and Fees</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Bank Fees Report</strong> with the <em>[Commissions and Fees Receipts]</em>, setting aside any receipts that are not listed in the <strong>QuickBook Report</strong>; add the total from the <em>[Commissions and Fees Receipts]</em> that were set aside with the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Commissions and Fees</ins></strong> for <em><ins>Form 1040 Schedule C Line 10</ins></em>.</li>
</ul>
<strong>QuickBooks Commissions Report</strong> --> <strong>QuickBooks Contract Labor Report</strong> --> <strong>QuickBooks Stipend Payments Report</strong> --> <em>[Contract Labor Receipts]</em> --> <em>[Contractor 1099's]</em> --> <strong><ins>Contract Labor</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Commissions Report</strong>, <strong>QuickBooks Contract Labor Report</strong>, and <strong>QuickBooks Stipend Payments Report</strong> with the <em>[Contract Labor Receipts]</em> and <em>[Contractor 1099's]</em>, setting aside any receipts that are not listed in the QuickBook Report; add the total from the <strong>Contract Labor Receipts</strong> that were set aside with the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Contract Labor</ins></strong> for <em><ins>Form 1040 Schedule C Line 11</ins></em>.</li>
</ul>
<em>[Previous Years Form 4562]</em> --> <em>[Current Years Form 4562]</em> --> <em>[Real Property Mortgage Receipt]</em> --> <em>[Real Property Escrow Receipts]</em> --> <em>[Capital Item Receipt]</em> --> <strong><em>Adjust Recovery Periods</em></strong> --> <strong><em>Current Year Depreciation %</em></strong> --> <strong><ins>Depreciation</ins></strong>
<ul>
<li>Correlate the <em>[Previous Years Form 4562]</em> with the <em>[Current Years Form 4562]</em>, <em>[Real Property Mortgage Receipt]</em>, <em>[Real Property Escrow Receipts]</em>, and <em>[Capital Item Receipt]</em>; carrying over depreciable property from the <em>[Previous Years Form 4562]</em>, making sure to <strong><em>Adjust the Recovery Period</em></strong> for the <em>[Current Years Form 4562]</em>, as well as recalculating the amount depreciable with the year being audited <strong><em>Current Year Depreciation Percentage</em></strong>. If a new piece equipment, vehicle, or property is purchased, then add in with the <em>[Current Years Form 4562]</em> and depreciate accordingly. This will come up with <strong><ins>Depreciation</ins></strong> for <em><ins>Form 1040 Schedule C Line 13</ins></em>.</li>
</ul>
<strong>QuickBooks Insurance Report</strong> --> <em>[Bank Statements]</em> --> <strong><ins>Insurance</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Insurance Report</strong> with the <em>[Bank Statements]</em>, verifying the payment records from the <strong>QuickBooks Report</strong>; add the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Insurance</ins></strong> for <em><ins>Form 1040 Schedule C Line 15</ins></em>.</li>
</ul>
<strong>QuickBooks Loan Interest Report</strong> --> <em>[Bank Statements]</em> --> <strong><ins>Mortgage Interest</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Loan Interest Report</strong> with the <em>[Bank Statements]</em>, verifying the payment records from the <strong>QuickBooks Report</strong>; add the total from the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Mortgage Interest</ins></strong> for <em><ins>Form 1040 Schedule C Line 16a</ins></em>.</li>
</ul>
<strong>QuickBooks Credit Card Interest Paid Report</strong> --> <strong>QuickBooks Isata Load Interest Report</strong> --> <em>[Bank Statements]</em> --> <strong><ins>Other Interest</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Credit Card Interest Paid Report</strong> and <strong>QuickBooks Isata Load Interest Report</strong> with the <strong>Bank Statements</strong>, verifying the payment records from the <strong>QuickBooks Report</strong>; add the total from the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Other Interest</ins></strong> for <em><ins>Form 1040 Schedule C Line 16b</ins></em>.</li>
</ul>
<strong>QuickBooks Professional Fees Report</strong> --> <em>[Legal and Professional Services Receipts]</em> --> <strong><ins>Legal and Profession Services</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Professional Fees Report</strong> with the <em>[Legal and Professional Services Receipts]</em>, setting aside any receipts that are not listed in the QuickBook Report; add the total from the <em>[Legal and Professional Services Receipts]</em> that were set aside with the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Legal and Profession Services</ins></strong> for <em><ins>Form 1040 Schedule C Line 17</ins></em>.</li>
</ul>
<em>[Vehicle, Machinery, or Equipment Rental Receipts]</em> --> <em>[Bank Statements]</em> --> <strong><ins>Vehicle, Machinery, or Equipment Rental</ins></strong>
<ul>
<li>Correlate the <em>[Vehicle, Machinery, or Equipment Rental Receipts]</em> with <em>[Bank Statements]</em>, add the total from the <em>[Vehicle, Machinery, or Equipment Rental Receipts]</em>. This will come up with <strong><ins>Vehicle, Machinery, or Equipment Rental</ins></strong> for <em><ins>Form 1040 Schedule C Line 20a</ins></em>.</li>
</ul>
<strong>QuickBook Office Rent Report</strong> --> <em>[Bank Statements]</em> --> <strong><ins>Other Business Property Rental</ins></strong>
<ul>
<li>Correlate the <strong>QuickBook Office Rent Report</strong> with <em>[Bank Statements]</em>, add the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Other Business Property Rental</ins></strong> for <em><ins>Form 1040 Schedule C Line 20b</ins></em>.</li>
</ul>
<strong>QuickBooks Repairs Report</strong> --> <strong>QuickBooks Facility Repairs/Improvements Report</strong> --> <em>[Repairs and Maintenance Receipts]</em> --> <strong><ins>Repairs and Maintenance</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Repairs Report</strong> and <strong>QuickBooks Facility Repairs/Improvements Report</strong> with the <em>[Repairs and Maintenance Receipts]</em>, setting aside add the total from the <em>[Repairs and Maintenance Receipts]</em>, setting aside any receipts that are not listed in the <strong>QuickBook Report</strong>. This will come up with <strong><ins>Repairs and Maintenance</ins></strong> for <em><ins>Form 1040 Schedule C Line 21</ins></em>.</li>
</ul>
<strong>QuickBooks Shop Supplies Report</strong> --> <em>[Supplies Receipts]</em> --> <strong><ins>Supplies</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Shop Supplies Report</strong> with the <em>[Supplies Receipts]</em>, setting aside any receipts that are not listed in the QuickBook Report; add the total from the <em>[Supplies Receipts]</em> that were set aside with the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Supplies</ins></strong> for <em><ins>Form 1040 Schedule C Line 22</ins></em>.</li>
</ul>
<strong>QuickBooks Total Property Tax Report</strong> --> <em>[Bank Statements]</em> --> <strong><ins>Taxes and Licenses</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Total Property Tax Report</strong> with the <em>[Bank Statements]</em>, add the total from the <strong>QuickBooks Report</strong>. This will come up with <strong><ins>Taxes and Licenses</ins></strong> for <em><ins>Form 1040 Schedule C Line 23</ins></em>.</li>
</ul>
<strong>QuickBooks Contractor Expense Reimbursement Report</strong> --> <strong>QuickBooks Travel Report</strong> --> <strong>QuickBooks Lodging Report</strong> --> <em>[Travel Expense Receipts]</em> --> <strong><ins>Travel</ins></strong>
<ul>
<li>Correlate the <strong>QuickBooks Contractor Expense Reimbursement Report</strong>, <strong>QuickBooks Travel Report</strong>, and <strong>QuickBooks Lodging Report</strong> with the <em>[Travel Expense Receipts]</em>, setting aside any receipts that are not listed in the QuickBook Report; add the total from the <strong>Travel Expense Receipts</strong> that were set aside with the total from the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Travel</ins></strong> for <em><ins>Form 1040 Schedule C Line 24a</ins></em>.</li>
</ul>
<ul>
<li><em>[Deductible Meal and Entertainment Receipts]</em> --> <em>[Bank Statements]</em> --> <strong><ins>Deductible Meals and Entertainment</ins></strong></li>
<li>Correlate the <em>[Deductible Meal and Entertainment Receipts]</em> with <em>[Bank Statements]</em>, add the total from the <em>[Deductible Meal and Entertainment Receipts]</em>. This will come up with <strong><ins>Deductible Meals and Entertainment</ins></strong> for <em><ins>Form 1040 Schedule C Line 24b</ins></em>.<br /><strong>NOTE</strong>: All food expenses are 50% deductible, so make sure to divide the total of this part by 2.</li>
</ul>
<strong>QuickBook Product Development Report</strong> --> <em>[Product Development Receipts]</em> --> <strong>QuickBook Dues and Subscriptions Report</strong> --> <em>[Dues and Subscriptions Receipts]</em> --> <strong>QuickBook Executive Dining Area Report</strong> --> <em>[Executive Dining Area Receipts]</em> --> <strong><ins>Other Expenses</ins></strong>
<ul>
<li>Correlate the <strong>QuickBook Product Development Report</strong> with <em>[Product Development Receipts]</em>, add the total from the <strong>QuickBooks Reports</strong> and any <em>[Product Development Receipts]</em> not found in the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Product Development</ins></strong> for <em><ins>Form 1040 Schedule C Part V</ins></em>.</li>
<li>Correlate the <strong>QuickBook Dues and Subscriptions Report</strong> with <em>[Dues and Subscriptions Receipts]</em>, add the total from the <strong>QuickBooks Reports</strong> and any <em>[Dues and Subscriptions Receipts]</em> not found in the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Dues and Subscriptions</ins></strong> for <em><ins>Form 1040 Schedule C Part V</ins></em>.</li>
<li>Correlate the <strong>QuickBook Executive Dining Area Receipts Report</strong> with <em>[Executive Dining Area Receipts Receipts]</em>, add the total from the <strong>QuickBooks Reports</strong> and any <em>[Executive Dining Area Receipts Receipts]</em> not found in the <strong>QuickBooks Reports</strong>. This will come up with <strong><ins>Executive Dining Area Receipts</ins></strong> for <em><ins>Form 1040 Schedule C Part V</ins></em>.</li>
<li>Add up the amounts of each of the other expense categories, making sure to divide all food related amounts are divided by 2, to come up with the total for <strong><ins>Other Expenses</ins></strong>.<br /><strong>NOTE</strong>: All food expenses are 50% deductible, so make sure to divide the total of this part by 2.</li>
</ul>
By now you should have:
<ol>
<li><ins>Advertising</ins>* for <em><ins>Form 1040 Schedule C Line 8</ins></em></li>
<li><ins>Car and Truck Expenses</ins>* for <em><ins>Form 1040 Schedule C Line 9</ins></em></li>
<li><ins>Commissions and Fees</ins>* for <em><ins>Form 1040 Schedule C Line 10</ins></em></li>
<li><ins>Contract Labor</ins>* for <em><ins>Form 1040 Schedule C Line 11</ins></em></li>
<li><ins>Depreciation</ins>* for <em><ins>Form 1040 Schedule C Line 13</ins></em></li>
<li><ins>Insurance</ins>* for <em><ins>Form 1040 Schedule C Line 15</ins></em></li>
<li><ins>Mortgage Interest</ins>* for <em><ins>Form 1040 Schedule C Line 16a</ins></em></li>
<li><ins>Other Interest</ins>* for <em><ins>Form 1040 Schedule C Line 16b</ins></em></li>
<li><ins>Legal and Profession Services</ins>* for <em><ins>Form 1040 Schedule C Line 17</ins></em></li>
<li><ins>Vehicle, Machinery, or Equipment Rental</ins>* for <em><ins>Form 1040 Schedule C Line 20a</ins></em></li>
<li><ins>Supplies</ins>* for <em><ins>Form 1040 Schedule C Line 22</ins></em></li>
<li><ins>Taxes and Licenses</ins>* for <em><ins>Form 1040 Schedule C Line 23</ins></em></li>
<li><ins>Travel</ins>* for <em><ins>Form 1040 Schedule C Line 24a</ins></em></li>
<li><ins>Deductible Meals and Entertainment</ins>* for <em><ins>Form 1040 Schedule C Line 24b</ins></em></li>
<li><ins>Other Expenses</ins>* for <em><ins>Form 1040 Schedule C Line 27</ins></em></li>
</ol>
<a name="Phase-3-Wrap-Up"></a>
<h2 >Phase 3 - Wrap Up<a href="#Phase-3-Wrap-Up" class="wiki-anchor">¶</a></h2>
<p>At this point any financial discrepancy for the year being audited has been found, noted, explained, corrected (if necessary), and compensated for. Once this phase has been completed, the actual auditing process is over and the next phase will be easier. To make the next phase easier make sure the tax category envelopes are organized in their small plastic container, obtain a medium sized plastic container for the manila folders and larger paper bundles, and all relevant tax forms for the year being audited.</p>
<hr />
<a name="Phase-4-Putting-It-All-Together"></a>
<h1 ><strong>Phase 4</strong>: Putting It All Together<a href="#Phase-4-Putting-It-All-Together" class="wiki-anchor">¶</a></h1>
<p>This phase is where the amounts of each tax category will be used to fill their respective values in the <strong><ins>Tax Filing Bundle</ins></strong>; as well as organize every receipt, bank statement, QuickBooks Reports, or various business financial transaction into a Financial Record Bundle</p>
<p><strong><ins>WARNING</ins></strong>: When creating <strong><ins>Tax and Financial Record Bundles</ins></strong> to send to an auditor, <ins>NEVER SEND ORIGINAL DOCUMENTS</ins>. Always, always, <ins>always</ins> create photocopied duplicates of specific parts request by an auditor, and if need by the whole bundle.</p>
<a name="Putting-together-the-Tax-Filing-Bundle"></a>
<h2 >Putting together the <ins>Tax Filing Bundle</ins><a href="#Putting-together-the-Tax-Filing-Bundle" class="wiki-anchor">¶</a></h2>
<p>Every business is different not only in the products and services they deliver, but also differ in how they chose to structure their tax liability. Simply put, a business will have a tax bundle a set of forms specific to that business; some businesses may have similar bundles while others may be completely different.</p>
<p><strong>NOTE</strong>: This guide is structured towards sole proprietor small-medium businesses, and as such the forms used are relative towards that. Please keep this in mind if the business being audited are different business types.</p>
<a name="Finding-the-relevant-Forms-Instructions-and-Publications"></a>
<h3 >Finding the relevant Forms, Instructions, and Publications<a href="#Finding-the-relevant-Forms-Instructions-and-Publications" class="wiki-anchor">¶</a></h3>
<p>The IRS provides all of their forms, instructional documents, and publications on their website <a class="external" href="http://www.irs.gov">http://www.irs.gov</a></p>
<p>The IRS also provides an archive for each specific year at <a class="external" href="http://www.irs.gov/pub/irs-prior/">http://www.irs.gov/pub/irs-prior/</a><br />Even better, the PDF files for each of the IRS documents are saved in an easily parseable format!</p>
<ul>
<li>Open up a web browser or new tab and in the URL bar enter in <a class="external" href="http://www.irs.gov/pub/irs-prior/p535--2011.pdf">http://www.irs.gov/pub/irs-prior/p535--2011.pdf</a>
<ul>
<li>This will open or download the PDF of <strong><em>Publication 535 for 2011</em></strong>; notice in the URL string <strong>"p", "535", and "2011"</strong>. This is the general naming scheme for the IRS forms and documents.</li>
</ul></li>
</ul>
<ul>
<li>Using the example above, tweak the URL string slightly by entering in <a class="external" href="http://www.irs.gov/pub/irs-prior/f1040sc--2011.pdf">http://www.irs.gov/pub/irs-prior/f1040sc--2011.pdf</a>
<ul>
<li>This will open or download the PDF of <strong><em>Form 1040 Schedule C for 2011</em></strong>; notice in the URL string "f", "1040", "sc" , and "2011". This naming scheme makes it possible to quickly get to any Form, Instructional, Publication document for any given year.</li>
</ul></li>
</ul>
<ul>
<li>Using the example above, tweak the URL string slightly by entering in <a class="external" href="http://www.irs.gov/pub/irs-prior/i1040--2010.pdf">http://www.irs.gov/pub/irs-prior/i1040--2010.pdf</a>
<ul>
<li>This will open or download the PDF of <strong><em>Instructions of Form 1040 for 2010</em></strong>; notice in the URL string "i", "1040", and "2010". The naming scheme will only work for valid documents, a business must know which forms are necessary for filing.</li>
</ul></li>
</ul>
For another, refer to the following example:
<ul>
<li><ins>www . irs . gov / pub / irs-prior / <strong><document type> <document number></strong> -- <strong><document year></strong> .pdf</ins>
<ul>
<li><strong><document type></strong>: This can be one of three single letters; (1) "f" for <em>Forms</em>, (2) "i" for <em>Instructions</em>, and (3) "p" for <em>Publications</em></li>
<li><strong><document number></strong>: This will be the individual document number; these are usually numbers like "1040" and "4562", but there are a few that contain numbers and letters like "1040sse" and "1040x". </li>
<li><strong><document year></strong>: This will be the specific year of a document; this will always be a 4-digit number of the year like "1999" and "2012"</li>
</ul></li>
</ul>
<p>By now, understanding how to format URL requests should be as simple as modifying the URL string of the IRS archive.</p>
<p>Relevant Documents</p>
<ul>
<li><em>Instructions</em>
<ul>
<li><strong>1040</strong>: Instructions for Form 1040 (Individual Income Tax Return)</li>
<li><strong>1040x</strong>: Instructions for Form 1040X (Amended Individual Income Tax Return)</li>
<li><strong>1040sa</strong>: Instructions for Form 1040 Schedule A (Itemized Deductions)</li>
<li><strong>1040sc</strong>: Instructions for Form 1040 Schedule C (Profit or Loss From Business)</li>
<li><strong>1040sse</strong>: Instructions for Form 1040 Schedule SE (Self-Employment Tax)</li>
<li><strong>4562</strong>: Instructions for Form 4562 (Depreciation and Amortization)</li>
<li><strong>8829</strong>: Instructions for Form 8829 (Expenses for Business Use of Your Home)</li>
</ul></li>
</ul>
<ul>
<li><em>Publications</em>
<ul>
<li><strong>334</strong>: Tax Guide for Small Business</li>
<li><strong>501</strong>: Exemptions, Standard Deductions, and Filing Information</li>
<li><strong>535</strong>: Business Expenses</li>
<li><strong>550</strong>: Investment Income and Expenses</li>
<li><strong>970</strong>: Tax Benefits for Education</li>
<li><strong>4681</strong>: Canceled Debts, Foreclosures, Repossessions, and Abandonments</li>
</ul></li>
</ul>
<p><strong>NERD</strong>: I have made a bash script on Linux that grabs all documents specified in a variable in its code and organizes them into folders appropriately. I will post a copy of the script here for posterity.</p>
<p><strong>NERD++</strong>: The above mentioned script is a simple text script file, similar to a Windows Batch Script. A similar script for Windows should be possible.</p>
<a name="Creating-a-Blank-Tax-Filing-Bundle"></a>
<h3 >Creating a Blank <strong><ins>Tax Filing Bundle</ins></strong><a href="#Creating-a-Blank-Tax-Filing-Bundle" class="wiki-anchor">¶</a></h3>
<p>With the IRS archiving all of its documents, obtaining all relevant forms and documents for creating a a blank <strong><ins>Tax Filing Bundle</ins></strong>.</p>
This part it as easy as:
<ol>
<li>Downloading the all relevant forms from the IRS website.</li>
<li>Printing out two copies of each form being used in the <strong><ins>Tax Filing Bundle</ins></strong>.</li>
<li>Organizing the two separate bundles, paying attention to the <strong><em>Attachment Sequence Number</em></strong> order in the upper right corner of each form attachment.</li>
<li>Staple each separate bundle once in the upper left corner.<br />NOTE: It is a good idea to keep a spare blank, mistakes do happen.</li>
</ol>
<p>Understanding which forms are needed for filing a tax return for a business is a difficult task; since tax policies, rules, credits, readjustments, special programs are added, removed, or modified from year to year.</p>
<blockquote>
<p>A good example of this are changes in the depreciation percentage tables, some years may have a low initial recovery percentage rate and may change to a slightly higher recovery percentage rate for the adjusted recovery period.</p>
</blockquote>
<p>Since this guide is structured towards sole proprietor small-medium businesses I have a fairly general idea of the forms relevant for the current years tax filing.</p>
<ul>
<li><em>Forms</em>
<ul>
<li><strong>1040</strong>: Form 1040 (Individual Income Tax Return)</li>
<li><strong>1040x</strong>: Form 1040X (Amended Individual Income Tax Return)</li>
<li><strong>1040sa</strong>: Form 1040 Schedule A (Itemized Deductions)</li>
<li><strong>1040sc</strong>: Form 1040 Schedule C (Profit or Loss From Business)</li>
<li><strong>1040sse</strong>: Form 1040 Schedule SE (Self-Employment Tax)</li>
<li><strong>4562</strong>: Form 4562 (Depreciation and Amortization)</li>
<li><strong>8829</strong>: Form 8829 (Expenses for Business Use of Your Home)</li>
</ul></li>
</ul>
<p>Once the above forms have been printed, sorted, and bundled it will be time to fill out the <strong><ins>Tax Filing Bundle</ins></strong>.</p>
<a name="Creating-a-Complete-Tax-Filing-Bundle"></a>
<h3 >Creating a Complete <strong><ins>Tax Filing Bundle</ins></strong><a href="#Creating-a-Complete-Tax-Filing-Bundle" class="wiki-anchor">¶</a></h3>
<p>When all of the all the phases and steps up to this point have been completed as best as possible, everything required to fill out the <strong><ins>Tax Filing Bundle</ins></strong> will be gathered, verified, ticker taped, totaled, organized, and bundled. And if the envelopes were labeled and organized properly, then the process of filling out the <strong><ins>Tax Filing Bundle</ins></strong> will be as simple as filling in the <strong><em>Total Amounts</em></strong> written on the exterior of each <strong><em>Tax Category</em></strong> envelope.</p>
<p><strong>NOTE</strong>: The <strong><ins>Gross Receipts or Sales</ins></strong> on Line 1 of Form 1040 Schedule C is the total amount invoiced for the year being audited, this includes invoiced amounts written as <strong><ins>Allowances</ins></strong> (they are totaled and subtracted from the gross receipts during the filing process).</p>
<p>NOTE: Certain forms will require other forms to be completed before completing the original form. Such as Form 1040 needing the first part to be completed to come up with amounts needed to complete Form 1040 Schedule A. Pay attention to every form directions carefully.</p>
<a name="Starting-with-the-Form-1040-Schedule-C"></a>
<h3 >Starting with the Form 1040 Schedule C<a href="#Starting-with-the-Form-1040-Schedule-C" class="wiki-anchor">¶</a></h3>
<p>*Begin by filling out the information about the business; proprietor name, business name, business type, SSN, etc. necessary for the filing.</p>
<ul>
<li>On <em><ins>Line 1 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Gross Receipts or Sales</strong> .</li>
</ul>
<ul>
<li>On <em><ins>Line 2 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Allowances</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 38 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Materials</strong>; needed for Line 4.</li>
</ul>
<ul>
<li>On <em><ins>Line 39 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Shipping Expenses</strong>; needed for Line 4.</li>
</ul>
<ul>
<li>On <em><ins>Line 4 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Cost of Goods Sold</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 6 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Other Income</strong>.</li>
</ul>
<p>At this point there will be enough information entered to calculate <strong><em>Gross Income</em></strong>.</p>
<ul>
<li>On <em><ins>Line 8 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Advertising</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 9 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Vehicle Expenses</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 10 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Commissions and Fees</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 11 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Contract Labor</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 12 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Depletion</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 13 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Depreciation</strong>. <strong>Requires Form 4562</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 14 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Employee Benefit Programs</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 15 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Insurance</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 16a of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Mortgage Interest Paid</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 16b of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Other Interest Paid</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 17 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Legal and Professional Services</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 18 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Office Expenses</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 19 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Pension or Profit-Sharing Plans</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 20a of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Rent or Lease of vehicles, machinery, and equipment</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 20b of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Rent or Lease of other business property</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 21 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Repairs and Maintenance</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 22 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Supplies</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 23 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Taxes and Licenses</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 24a of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Travel Expenses</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 24b of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Deductible Meals and Entertainment</strong>. <strong>Only 50% deductible</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 25 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Utilities</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 26 of Form 1040 Schedule C</ins></em> use the verified total of the <strong>Wages</strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 27 of Form 1040 Schedule C</ins></em> use the verified total of the <strong><ins>Other Expenses</ins></strong> from Part V.
<ul>
<li><strong>Product Research & Development</strong>: This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Dues & Subscriptions</strong>: This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>.</li>
<li><strong>Executive Dining Area</strong>: This is for <em><ins>Part V of Form 1040 Schedule C</ins></em>. <strong>Only 50% deductible</strong>.</li>
</ul></li>
</ul>
<p>At this point there will be enough information entered to calculate <strong><em>Total Expenses</em></strong>.</p>
<ul>
<li> On <em><ins>Line 30 of Form 1040 Schedule C</ins></em> use the amount from Form 8829 for <strong>Expenses for Business Use of Home</strong>. <strong>Requires Form 8829</strong></li>
</ul>
<p>At this point there will be enough information entered to calculate <strong><em>Net Profit</em></strong> to be later used on <em><ins>Line 12 of Form 1040</ins></em>.</p>
<p>Form 1040 Schedule C is now complete.</p>
<a name="Optional-Form-4562"></a>
<h3 >(Optional) Form 4562<a href="#Optional-Form-4562" class="wiki-anchor">¶</a></h3>
<p><strong>NOTE</strong>: This form must be completed before finishing Form 1040 Schedule C</p>
<p>This form is a a little bit more in depth. To come up with depreciation values, the value of a equipment, vehicles, and property are calculated based on classification (years to be deducted), basis (original cost), recovery period (adjusted amount years left for depreciation), convention (monthy, quarterly, etc.), and method (to specify which depreciation system used).</p>
<p>For more information consult the Instructions for Form 4562.</p>
<a name="Optional-Form-8829"></a>
<h3 >(Optional) Form 8829<a href="#Optional-Form-8829" class="wiki-anchor">¶</a></h3>
<p><strong>NOTE</strong>: This form must be completed before finishing Form 1040 Schedule C</p>
<p>If there is a part of your personal home that is used for the business, the percentage used is deductible.</p>
<ul>
<li>The form takes the <strong><em>Total Area of Home</em></strong> and divides it by <strong><em>Area Used for Business</em></strong> to come up with a percentage to be deducted from the tentative profit from Form 1040 Schedule C.</li>
</ul>
<ul>
<li>Along with the deductible percentage of space, direct and indirect expenses relating to the personal home are deductible; such as mortgage interest, real estate taxes, and casualty losses.</li>
</ul>
<ul>
<li>When all amounts are entered and calculated the amount for <strong><em>Allowable Expenses for Business Use of Your Home</em></strong> to used on <em><ins>Line 30 of Form 1040 Schedule C</ins></em>.</li>
</ul>
<p>Form 8829 is now complete.</p>
<a name="Moving-on-with-Form-1040-Schedule-SE"></a>
<h3 >Moving on with Form 1040 Schedule SE<a href="#Moving-on-with-Form-1040-Schedule-SE" class="wiki-anchor">¶</a></h3>
<p>This form is relatively simple, if using the short form; which will be used in this case.</p>
<ul>
<li>Take the totaled amount from <em><ins>Line 31 of Form 1040 Schedule C</ins></em> and enter it into <em><ins>Line 2 of Form 1040 Schedule SE Short</ins></em>.</li>
</ul>
<ul>
<li>Follow the forms steps to come up with the amount for <em><ins>Line 5 of Form 1040 Schedule SE Short</ins>. This is the <strong>_Self-Employment Tax</em></strong> to be later used on <em><ins>Line 56 of Form 1040</ins></em></li>
</ul>
<ul>
<li>The <strong><em>Self-Employment Tax</em></strong> is 50% deductible, so the amount from <strong><em>Self-Employment Tax</em></strong> and divide it by 2, to come up with an amount for <em><ins>Line 6 of Form 1040 Schedule SE Short</ins></em>. This is the amount of <strong><em>Deductible Self-Employment Tax</em></strong> to be later used on <em><ins>Line 27 of Form 1040</ins></em>.</li>
</ul>
<p>Form 1040 Schedule SE is now complete.</p>
<a name="Beginning-Form-1040"></a>
<h3 >Beginning Form 1040<a href="#Beginning-Form-1040" class="wiki-anchor">¶</a></h3>
<ul>
<li>Start by entering in all the relevant and necessary information; such as name, spouses name, dependents names, SSNs, city, state, filing status, etc.</li>
</ul>
<ul>
<li>On <em><ins>Line 12 of Form 1040</ins></em> enter the amount from the <strong><em>Net Profit</em></strong> from _<ins>Line 31 of Form 1040 Schedule C</ins>.</li>
</ul>
<ul>
<li>On <em><ins>Line 22 of Form 1040</ins></em> add up the amount instructed to come up with the <strong><ins>Total Income</ins></strong></li>
</ul>
<ul>
<li>On <em><ins>Line 27 of Form 1040</ins></em> enter the amount from the <strong><em>Deductible Self-Employment Tax</em></strong> to be later used on <em><ins>Line 27 of Form 1040</ins></em>.</li>
</ul>
<ul>
<li>On <em><ins>Line 36 of Form 1040</ins></em> enter the amount instructed to come up with the <strong><ins>Total Personal Deductible Expenses</ins></strong> to be later used on <em><ins>Line 37 of Form 1040</ins></em>.</li>
</ul>
<p>On <em><ins>Line 37 of Form 1040</ins></em> enter the amount instructed to come up with the <strong>Adjusted Gross Income</strong> to be later used on <em><ins>Line 38 of Form 1040</ins></em> and <em><ins>Line 2 of Form 1040 Schedule A</ins></em>.</p>
<p>Form 1040 is half complete.</p>
<a name="Completing-Form-1040-Schedule-A"></a>
<h3 >Completing Form 1040 Schedule A<a href="#Completing-Form-1040-Schedule-A" class="wiki-anchor">¶</a></h3>
<ul>
<li>On <em><ins>Line 1 of Form 1040 Schedule A</ins></em> enter in the total of medical receipts and statements to come up with the <strong><em>Medical and Dental Expenses</em></strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 2 of Form 1040 Schedule A</ins></em> enter in the amount from <em><ins>Line 37 of Form 1040</ins></em></li>
</ul>
<ul>
<li>Follow the form directions to come up with the total amount of <strong><em>Deductible Medical Expenses</em></strong></li>
</ul>
<ul>
<li>On <em><ins>Line 5 of Form 1040 Schedule A</ins></em> enter in either paid income tax or sales tax amounts to come up with <strong><em>Deductible Personal Paid Taxes</em></strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 7 of Form 1040 Schedule A</ins></em> enter in the paid property amount to come up with the <strong><em>Deductible Personal Property Taxes</em></strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 10 of Form 1040 Schedule A</ins></em> enter in the paid home mortgage interest amount to come up with <strong><em>Deductible Home Property Mortgage</em></strong>.</li>
</ul>
<ul>
<li>Complete any further relevant itemized deduction categories.</li>
</ul>
<ul>
<li>On <em><ins>Line 29 of Form 1040 Schedule A</ins></em> enter the amount instructed to come up with the <strong><em>Total Itemized Deductions</em></strong>, this will be used on <em><ins>Line 40 of Form</ins></em>.</li>
</ul>
<a name="Finishing-Form-1040"></a>
<h3 >Finishing Form 1040<a href="#Finishing-Form-1040" class="wiki-anchor">¶</a></h3>
<ul>
<li>On <em><ins>Line 40 of Form 1040</ins></em> enter the <strong><em>Total Itemized Deductions</em></strong> from <em><ins>Line 29 of Form 1040 Schedule A</ins></em>.</li>
</ul>
<ul>
<li>On <em><ins>Line 42 of Form 1040</ins></em> follow the instructions to come up with the amount of <strong><em>Exemptions</em></strong></li>
</ul>
<ul>
<li>On <em><ins>Line 43 of Form 1040</ins></em> follow the instructions to come up with the amount of <strong><em>Taxable Income</em></strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 44 of Form 1040</ins></em> use the Instructions for Form 1040 to look at the taxable income tables; looking for the appropriate income range closest to the amount from <em><ins>Line 43 of Form 1040</ins></em>. The amount listed will be the amount of <strong><em>Tax</em></strong>.</li>
</ul>
<ul>
<li>If any tax credits are claimed, add them up and enter them into their appropriate areas.</li>
</ul>
<ul>
<li>On <em><ins>Line 61 of Form 1040</ins></em> follow the instructions to come up with the <strong><em>Total Tax</em></strong>.</li>
</ul>
<ul>
<li>On <em><ins>Line 72 of Form 1040</ins></em> if any payments were applied, enter their values appropriately, and add the total to come up with <strong><em>Total Payments</em></strong></li>
</ul>
<ul>
<li>On <em><ins>Line 76 of Form 1040</ins></em> follow the instructions to come up with the total <strong><em>Amount You Owe</em></strong>.</li>
</ul>
<p>Once all the amounts are calculated and entered, the bundle needs signatures and the <strong><ins>Tax Filing Bundle</ins></strong> will be complete.</p>
<a name="Putting-together-the-Financial-Record-Bundle"></a>
<h2 >Putting together the <ins>Financial Record Bundle</ins><a href="#Putting-together-the-Financial-Record-Bundle" class="wiki-anchor">¶</a></h2>
<p>Now that the <strong><ins>Tax Filing Bundle</ins></strong> is complete, everything is ready for presentation to an auditor, or for archival purposes.</p>
<ul>
<li>Using the medium-sized plastic container for the folders and paper bundles, make sure that all of the documents, notes, reports, and folders are stored flatly on the bottom of the container.</li>
</ul>
<ul>
<li>Next remove all paper clips and mainstays from the tax category envelopes. Ticker tapes should be permanently stapled to their corresponding tax category envelope.</li>
</ul>
<ul>
<li>If there is enough room to fit the contents of the small-plastic container holding the tax category envelopes, then place the tax category envelopes in an organized way that will not crumple, squish, or wrinkle the contents.</li>
</ul>
<ul>
<li>Using a piece of tape and a sharpie, label the medium-sized container with the year of the containing files.</li>
</ul>
<hr />
<a name="Resources"></a>
<h1 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h1>
<ul>
<li><a class="external" href="http://www.irs.gov">http://www.irs.gov</a></li>
<li><a class="external" href="http://caps.fool.com/Blogs/schedule-c-what-expenses-go/171890">http://caps.fool.com/Blogs/schedule-c-what-expenses-go/171890</a></li>
<li><a class="external" href="http://www.moneycrashers.com/irs-schedule-c-tax-deductions-expenses-small-business/">http://www.moneycrashers.com/irs-schedule-c-tax-deductions-expenses-small-business/</a></li>
<li><a class="external" href="http://www.moneycrashers.com/tax-deductions-self-employed-business/">http://www.moneycrashers.com/tax-deductions-self-employed-business/</a></li>
</ul> GNU/Linux Administration - Bug #409 (Closed): Recovering Files From A LUKS and eCryptfs Encrypted...https://project.altservice.com/issues/4092014-07-07T19:34:08ZDaniel Curtistechsupport@altservice.com
<p>I've encountered a problem where I have lost my USB booloader used to boot into my primary OS; which consists of two LUKS encrypted partitions, one for / and one for /home. Not only were the partitions encrypted, but also the user folders via ecryptfs. Luckily, I was not ultra-paranoid and only used a passphrase with LUKS and not a passphrase/keyfile combination. To begin I booted into a live ubuntu environment and dropped into a root shell:<br /><pre>
sudo su
</pre></p>
<a name="Open-and-mount-the-LUKS-containers"></a>
<h2 >Open and mount the LUKS containers<a href="#Open-and-mount-the-LUKS-containers" class="wiki-anchor">¶</a></h2>
<ul>
<li>First open up the LUKS encrypted partitions:<br /><pre>
cryptsetup luksOpen /dev/sda5 root
cryptsetup luksOpen /dev/sda6 home
</pre><br />NOTE: This will prompt for a passphrase. Recovering the passphrase is beyond the scope of this guide.</li>
</ul>
<ul>
<li>Next, mount the mapped partitions:<br /><pre>
mount /dev/mapper/root /mnt
mount /dev/mapper/home /mnt/home
</pre></li>
</ul>
<ul>
<li>Mount the device, process, and system mountpoints:<br /><pre>
mount --bind /dev /mnt/dev
mount --bind /sys /mnt/sys
mount --bind /proc /mnt/proc
</pre></li>
</ul>
<a name="Mount-the-Read-Only-eCryptfs"></a>
<h2 >Mount the Read-Only eCryptfs<a href="#Mount-the-Read-Only-eCryptfs" class="wiki-anchor">¶</a></h2>
<p>Now that I had access to both my root and home partitions, I needed to recover my personal files. These were encrypted using ecryptfs, and it just so happens there is a tool just for recovering ecryptfs partition.</p>
<ul>
<li>From the root terminal, run the recovery command:<br /><pre>
ecryptfs-recover-private
</pre><br />This will prompt a few questions including the login passphase of the user's directory that recovery is ran on. Once the recovery is complete, a read-only version will be available.</li>
</ul>
<a name="Transfer-the-files-to-another-machine"></a>
<h2 >Transfer the files to another machine<a href="#Transfer-the-files-to-another-machine" class="wiki-anchor">¶</a></h2>
<p>Now that I had access to my files, I used rsync to backup my files to another machine:<br /><pre>
cd /tmp/ecrypt.63f8g4
rsync -avh --progress -n . -e ssh user@backup.example.com:/path/to/backup/folder
</pre><br />NOTE: Make sure to remove the -n flag to remove the 'dry-run' option.</p>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<ul>
<li><a class="external" href="http://citizen428.net/blog/2011/10/17/fixing-grub-on-a-luks-encrypted-disk">http://citizen428.net/blog/2011/10/17/fixing-grub-on-a-luks-encrypted-disk</a></li>
<li><a class="external" href="https://help.ubuntu.com/12.04/serverguide/ecryptfs.html">https://help.ubuntu.com/12.04/serverguide/ecryptfs.html</a></li>
<li><a class="external" href="https://help.ubuntu.com/community/EncryptedPrivateDirectory">https://help.ubuntu.com/community/EncryptedPrivateDirectory</a></li>
</ul> Website Hosting - Bug #295 (Closed): Viewing Redmine Issues Causing Error 500https://project.altservice.com/issues/2952014-01-10T15:41:59ZDaniel Curtistechsupport@altservice.com
<p>While trying to figure out another problem in Redmine, I ended up breaking the function of viewing issues. After trying numerous things to fix it ranging from unintalling/reinstalling the rails gem, upgrading ruby versions, and even upgrading Phusion Passenger; all to no avail. I decided to view the <strong>log/production.log</strong> in the redmine directory to find the following error:</p>
<blockquote>
<p>Processing by IssuesController#index as HTML<br />Current user: <a class="email" href="mailto:user@example.com">user@example.com</a> (id=74)<br />Rendered queries/_filters.html.erb (64.6ms)<br />Rendered queries/_columns.html.erb (40.9ms)<br />Rendered issues/_list.html.erb (492.2ms)<br />Rendered issues/_sidebar.html.erb (62.9ms)<br />Rendered issues/index.html.erb within layouts/base (912.5ms)<br />Completed 500 Internal Server Error in 4683ms</p>
<p>ActionView::Template::Error (Mysql2::Error: Unknown column 'queries.is_public' in 'where clause': SELECT `queries`.`id` AS t0_r0, `queries`.`project_id` AS t0_r1, `queries`.`name` AS t0_r2, `queries`.`filters` AS t0_r3, `queries`.`user_id` AS t0_r4, `queries`.`column_names` AS t0_r5, `queries`.`sort_criteria` AS t0_r6, `queries`.`group_by` AS t0_r7, `queries`.`type` AS t0_r8, `queries`.`visibility` AS t0_r9, `queries`.`options` AS t0_r10, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`inherit_members` AS t1_r12 FROM `queries` LEFT OUTER JOIN `projects` ON `projects`.`id` = `queries`.`project_id` WHERE `queries`.`type` IN ('IssueQuery') AND ((queries.project_id IS NULL OR (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.is_public = 1 OR projects.id IN (33,10,51,34,29,4,55,1,2,28,38,16,36,23,13,37,18,3,26,27,5,11,53,6,15,14,24,67,69,7,35,57,46,65,45,32,63,22,31,59,61,42,40,44,49,50,25,30,39,43,47,48,21,20,19,17,41))))) AND (queries.is_public = 1 OR queries.user_id = 4)) AND (project_id IS NULL) ORDER BY queries.name ASC):<br />17: <%= call_hook(:view_issues_sidebar_issues_bottom) <span>><br />18: <</span>= call_hook(:view_issues_sidebar_planning_bottom) <span>><br />19: <br />20: <</span>= render_sidebar_queries <span>><br />21: <</span>= call_hook(:view_issues_sidebar_queries_bottom) %><br />app/helpers/issues_helper.rb:187:in `sidebar_queries'<br />app/helpers/issues_helper.rb:214:in `render_sidebar_queries'<br />app/views/issues/_sidebar.html.erb:20:in `_app_views_issues__sidebar_html_erb__1041431284_95856650'<br />app/views/issues/index.html.erb:93:in `block in <em>app_views_issues_index_html_erb</em>__594514544_88597730'<br />app/helpers/application_helper.rb:1149:in `content_for'<br />app/views/issues/index.html.erb:92:in `_app_views_issues_index_html_erb___594514544_88597730'<br />app/controllers/issues_controller.rb:83:in `block (2 levels) in index'<br />app/controllers/issues_controller.rb:82:in `index'</p>
</blockquote>
<p>Due to the emergency situation, I moved the existing redmine folder and copied a known working version from a backup:<br /><pre>
mv /var/www/path/to/redmine /var/www/path/to/redmine.brk
rsync -avh -n /var/backups/path/of/backup/redmine /var/www/path/to/redmine
</pre><br />Note: Remove the -n flag to initiate the actual transfer. Always dry-run rsync to prevent hazards.</p>
<p>I then refresh the bundled gems <ins>on every instance of redmine</ins>:<br /><pre>
cd /var/www/path/to/redmine
bundle exec rake db:migrate RAILS_ENV=production
</pre></p>
<p>This still did not fix the problem. Though after reading through the redmine forum, I found that someone else encountered this issue, the solution was simple. Log into the redmine SQL database and run the following <br />statement:<br /><pre>
mysql -uredmine -p redmine -h redminedb
use redmine;
ALTER TABLE queries ADD is_public TINYINT NOT NULL DEFAULT 0;
</pre></p>
<p>I restarted all the Web servers:<br /><pre>
service apache2 restart
</pre></p>
<p>This fixed the problem.</p>
<a name="Resources"></a>
<h2 >Resources<a href="#Resources" class="wiki-anchor">¶</a></h2>
<p><a class="external" href="http://www.redmine.org/boards/2/topics/39622">http://www.redmine.org/boards/2/topics/39622</a></p> FreeBSD Administration - Support #293 (Closed): Upgrading FreeNAShttps://project.altservice.com/issues/2932014-01-06T20:59:34ZDaniel Curtistechsupport@altservice.com
<p>With the new version of FreeNAS coming out recently, I decided to upgrade to the newest version of FreeNAS. To begin I backed up the configuration of the existing FreeNAS server by logging into the FreeNAS panel and going <ins>Settings</ins> and selecting <strong>Save config</strong>.</p>
<p>From there I downloaded the newest FreeNAS version for flash and burned it onto new USB drive:<br /><pre>
xzcat FreeNAS-9.2.0-RELEASE-x64.img.xz | pv | dd bs=1M of=/dev/sdb
sync
</pre><br />Note: Make sure to flash <ins>to the correct device</ins> through <code>fdisk -l</code>.</p>
<p>I then replaced the original USB drive with the old version of FreeNAS with the newer USB drive and booted it up. After identifying the IP address, I opened a web browser and pointed it at the IP address of the FreeNAS box. I was immediately prompted to change the admin password, after doing so I went to the <ins>Settings</ins> of the new FreeNAS install and selected <strong>Upload Config</strong> and uploaded the configuration from the previous FreeNAS installation. I was again prompted to change the admin password, and again changed it.</p>
<p>The server upgrade finished with a few minor hiccups. One being the BIOS was not set to boot from the new USB drive, this was fixed by rebooting the machine and pressing [F2] at boot time and going to the <ins>Boot</ins> section and change the priority of the boot order.</p> Website Hosting - Support #130 (Closed): Installing Magento The Hard Wayhttps://project.altservice.com/issues/1302013-06-27T17:19:30ZDaniel Curtistechsupport@altservice.com
<p>During the initial deployment of demo.altservice.com I was unable to complete the normal web installation procedure. At first the error that prevented the install was:</p>
<blockquote>
<p>PHP Extension "0" must be installed</p>
</blockquote>
<p>I found the fix at Magento's <a href="http://www.magentocommerce.com/boards/viewthread/284882/" class="external">forum</a> however this led to the next error, a redirect loop. I was unable to locate the root cause of this problem, however I managed to work around this. The symptoms were a redirect loop just after filling out the database information on the web installer. This made the install impossible due to the <code>app/etc/local.xml</code> never being created.</p>
<p>I uploaded the Magento files to the web directory and set the proper permissions:<br /><pre>
sudo chmod o+w var var/.htaccess app/etc
sudo chmod -R o+w media
</pre></p>
<p>I then installed the Magento sample data to the demo site's database:<br /><pre>
mysql -h DB_HOST -u DB_USER -p DB_PASS < magento_sample_data.sql
</pre></p>
<p>After this step I had to create a local.xml file to contain the relevant database information for the demo.altservice.com instance. I have included a template XML file for use. Once the local.xml file was set in app/etc the Magento instance was resolved.</p>
<p>However there was one last problem before administration would work, I had to manually reset the password in the Magento database.</p>
<p>I logged into as such:<br /><pre>
mysql -h DB_HOST -u DB_USER -p DB_PASS
</pre></p>
<p>And reset the password with the following query:<br /><pre><code class="sql syntaxhl"><span class="k">UPDATE</span> <span class="n">admin_user</span> <span class="k">SET</span> <span class="n">password</span><span class="o">=</span><span class="n">CONCAT</span><span class="p">(</span><span class="n">MD5</span><span class="p">(</span><span class="s1">'qXpassword'</span><span class="p">),</span> <span class="s1">':qX'</span><span class="p">)</span> <span class="k">WHERE</span> <span class="n">username</span><span class="o">=</span><span class="s1">'admin'</span><span class="p">;</span>
</code></pre></p>
<p>Here is another copy of the local.xml file:<br /><pre><code class="xml syntaxhl"><span class="cp"><?xml version="1.0"?></span>
<span class="nt"><config></span>
<span class="nt"><global></span>
<span class="nt"><install></span>
<span class="nt"><date></span><span class="cp"><![CDATA[Tue, 08 May 2012 18:41:31 +0000]]></span><span class="nt"></date></span>
<span class="nt"></install></span>
<span class="nt"><crypt></span>
<span class="nt"><key></span><span class="cp"><![CDATA[MAGENTO_ENCRYPTION_KEY]]></span><span class="nt"></key></span>
<span class="nt"></crypt></span>
<span class="nt"><disable_local_modules></span>false<span class="nt"></disable_local_modules></span>
<span class="nt"><resources></span>
<span class="nt"><db></span>
<span class="nt"><table_prefix></span><span class="cp"><![CDATA[]]></span><span class="nt"></table_prefix></span>
<span class="nt"></db></span>
<span class="nt"><default_setup></span>
<span class="nt"><connection></span>
<span class="nt"><host></span><span class="cp"><![CDATA[DB_HOST]]></span><span class="nt"></host></span>
<span class="nt"><username></span><span class="cp"><![CDATA[DB_USER]]></span><span class="nt"></username></span>
<span class="nt"><password></span><span class="cp"><![CDATA[DB_PASS]]></span><span class="nt"></password></span>
<span class="nt"><dbname></span><span class="cp"><![CDATA[DB_NAME]]></span><span class="nt"></dbname></span>
<span class="nt"><initStatements></span><span class="cp"><![CDATA[SET NAMES utf8]]></span><span class="nt"></initStatements></span>
<span class="nt"><model></span><span class="cp"><![CDATA[mysql4]]></span><span class="nt"></model></span>
<span class="nt"><type></span><span class="cp"><![CDATA[pdo_mysql]]></span><span class="nt"></type></span>
<span class="nt"><pdoType></span><span class="cp"><![CDATA[]]></span><span class="nt"></pdoType></span>
<span class="nt"><active></span>1<span class="nt"></active></span>
<span class="nt"></connection></span>
<span class="nt"></default_setup></span>
<span class="nt"></resources></span>
<span class="nt"><session_save></span><span class="cp"><![CDATA[files]]></span><span class="nt"></session_save></span>
<span class="nt"></global></span>
<span class="nt"><admin></span>
<span class="nt"><routers></span>
<span class="nt"><adminhtml></span>
<span class="nt"><args></span>
<span class="nt"><frontName></span><span class="cp"><![CDATA[admin]]></span><span class="nt"></frontName></span>
<span class="nt"></args></span>
<span class="nt"></adminhtml></span>
<span class="nt"></routers></span>
<span class="nt"></admin></span>
<span class="nt"></config></span>
</code></pre></p> Website Hosting - Bug #65 (Closed): MySQL Fails to Start on Ubuntu at Boot Timehttps://project.altservice.com/issues/652013-02-06T22:45:43ZDaniel Curtistechsupport@altservice.com
<p>An unknown incident caused MySQL to fail starting up at boot time. This wiped out all of the data from every table and corrupted the <code>ibdata1</code> file. The engine used on this version of MySQL is InnoDB.</p>
<a name="1-Check-to-see-if-the-service-is-running"></a>
<h2 >1. Check to see if the service is running:<a href="#1-Check-to-see-if-the-service-is-running" class="wiki-anchor">¶</a></h2>
<pre>
sudo service mysql status
</pre>
<a name="2-Attempt-to-start-MySQL"></a>
<h2 >2. Attempt to start MySQL<a href="#2-Attempt-to-start-MySQL" class="wiki-anchor">¶</a></h2>
<pre>
sudo service mysql start
</pre>
<p>The service fails to start.</p>
<a name="3-Backup-the-corrupt-ib-files"></a>
<h2 >3. Backup the corrupt <code>ib</code> files<a href="#3-Backup-the-corrupt-ib-files" class="wiki-anchor">¶</a></h2>
<pre>
sudo mkdir /var/lib/mysql/bak
cp /var/lib/mysql/ib* /var/lib/mysql/bak
</pre>
<a name="4-Start-MySQL-service-with-InnoDB-recovery"></a>
<h2 >4. Start MySQL service with InnoDB recovery<a href="#4-Start-MySQL-service-with-InnoDB-recovery" class="wiki-anchor">¶</a></h2>
<pre>
mysqld --defaults-file=/etc/mysql/my.cnf --innodb-force-recovery=6
</pre>
<a name="5-Dump-the-recovered-MySQL-databases-to-backupsql"></a>
<h2 >5. Dump the recovered MySQL databases to <code>backup.sql</code><a href="#5-Dump-the-recovered-MySQL-databases-to-backupsql" class="wiki-anchor">¶</a></h2>
<pre>
mysqldump -u root -p --all-databases > backup.sql
</pre>
<a name="6-Stop-MySQL-service-with-InnoDB-recovery"></a>
<h2 >6. Stop MySQL service with InnoDB recovery<a href="#6-Stop-MySQL-service-with-InnoDB-recovery" class="wiki-anchor">¶</a></h2>
<pre>
ps -aux | grep mysql
kill -s kill <PID#>
</pre>
<a name="7-Purge-the-corrupt-ib-files"></a>
<h2 >7. Purge the corrupt <code>ib</code> files.<a href="#7-Purge-the-corrupt-ib-files" class="wiki-anchor">¶</a></h2>
<p><strong>NOTE</strong>: Remember to backup the corrupt <code>ib</code> files first. If something goes wrong with the working corrupt files, there will be nothing to fall back to.</p>
<pre>
sudo rm -rf /var/lib/mysql/ib*
</pre>
<a name="8-Start-the-normal-MySQL"></a>
<h2 >8. Start the normal MySQL<a href="#8-Start-the-normal-MySQL" class="wiki-anchor">¶</a></h2>
<pre>
sudo service mysql start
</pre>
<a name="9-Import-recovered-databases-from-backupsql"></a>
<h2 >9. Import recovered databases from <code>backup.sql</code><a href="#9-Import-recovered-databases-from-backupsql" class="wiki-anchor">¶</a></h2>
<pre>
sudo mysql -u root -p < backup.sql
</pre> GNet Solutions - Bug #44 (Closed): Recovery of a Partially Formatted RAID1 NAS Hard Drivehttps://project.altservice.com/issues/442013-01-16T20:52:24ZDaniel Curtistechsupport@altservice.com
<p>In the event of a hard disk failure in a RAID1 setup a rescue environment must be setup. I used D.E.F.T., but any linux with <code>mdadm</code> will suffice. For best practices, make sure to <ins>ALWAYS LOAD FROM RAM</ins>.</p>
<p>This will only work in a RAID1 (mirrored) array; RAID0, RAID5, RAID6, and JBOD are structured differently. Run through steps as followed.</p>
<a name="1-Boot-into-Linux-and-start-a-terminal-session-Start-gtAccessories-gtTerminal-NOTE-must-be-root"></a>
<h3 >1. Boot into Linux and start a terminal session. (Start->Accessories->Terminal) (NOTE: must be root)<a href="#1-Boot-into-Linux-and-start-a-terminal-session-Start-gtAccessories-gtTerminal-NOTE-must-be-root" class="wiki-anchor">¶</a></h3>
<a name="2-Run-the-command"></a>
<h3 >2. Run the command:<a href="#2-Run-the-command" class="wiki-anchor">¶</a></h3>
<pre>
mdadm --assemble --scan --run
</pre><br />This will scan for RAID partitions, assemble previously created arrays, and run the array.<br /><strong>NOTE</strong>: The md partitions listed by this command will be the partitions you need to mount. The Largest partitions in usually the Data partition
<p><strong>UPDATE</strong>: I could not get the RAID array to mount properly, so recovery could not happen. I managed to ultimately fix this by running e2fsck on the mdPartition# like so:<br /><pre>
e2fsck -y /dev/md2
</pre></p>
<a name="3-Next-the-command"></a>
<h3 >3. Next the command:<a href="#3-Next-the-command" class="wiki-anchor">¶</a></h3>
<pre>
mkdir /mnt/folder
</pre><br />This will make a directory in the <code>/mnt</code> folder that you name, as disignated by <code>folder</code>.<br /><strong>NOTE</strong>: if md partition is <code>/dev/md2</code> then make the directory <code>/mnt/md2</code>
<a name="4-Next-the-commant"></a>
<h3 >4. Next the commant:<a href="#4-Next-the-commant" class="wiki-anchor">¶</a></h3>
<pre>
mount /dev/mdPartition# /mnt/folder
</pre><br />This will mount the partition to the directory that was specified earlier.
<a name="5-Open-a-file-manager-Start-gtAccessories-gtFile-Manager-and-navigate-to-mntfolder"></a>
<h3 >5. Open a file manager <code>Start->Accessories->File Manager and</code> navigate to <code>/mnt/folder</code><a href="#5-Open-a-file-manager-Start-gtAccessories-gtFile-Manager-and-navigate-to-mntfolder" class="wiki-anchor">¶</a></h3>
<p>Successful mounting will display stored data.</p> Windows Administration - Bug #39 (Closed): QuickBooks Freezes and Will Not Loadhttps://project.altservice.com/issues/392013-01-16T19:18:12ZDaniel Curtistechsupport@altservice.com
<p>QuickBooks fails to load and freezes loading company file. The symptoms include QuickBooks database manager service is not running, as well as QuickBooks launching but failing to correctly load the company file proper. This bug is acknowledged by Intuit and affects any QuickBooks 2012 version updating to the R8 cycle, and is yet to be fixed by Intuit developers.</p>
The fix was not an easy one as Intuit suggest a full uninstall, removing ALL artifacts and registry values pertaining to QuickBooks, and reinstalling from scratch, and importing backed up company files. The steps I used to correct the problem are as followed:
<ol>
<li>Repair QuickBooks from <code>[Start Menu -> Control Panel -> Programs and Features]</code></li>
<li>Repair Microsoft .NET 3.5 and .NET 4 extended from <code>[Start Menu -> Control Panel -> Programs and Features]</code></li>
<li>Tested Company file connectivity with QuickBooks Network Diagnostic Tool.</li>
<li>Renamed the <code>QBWUSER.INI</code> file in <code>C:Users\username\App Data\Local\Intuit\QuickBooks 2012</code></li>
<li>Repair the QuickBooks .dll and .ocx shared libraries by running <code>reboot.bat</code> from the folder where QuickBooks was installed, i.e. <code>C:\Program Files\Intuit</code>.</li>
<li>Loaded QuickBooks without autoloading Company file by holding <code>Control</code> while loading QuickBooks</li>
<li>Verified Company file (for each company file), done by <code>[File -> Utilities -> Verify Data]</code></li>
<li>Rebuild Company file (for each company file), done by <code>[File -> Utilities -> Rebuild Data]<br /></code></li>
</ol>
<p>The symptoms stopped right after I repaired the .dll and .ocx files and Verified and Rebuild the Company file data. I will continue to monitor the for anymore symptoms.</p>
<a name="Accessing-QuickBooks-Developer-Logfiles"></a>
<h3 >Accessing QuickBooks Developer Logfiles<a href="#Accessing-QuickBooks-Developer-Logfiles" class="wiki-anchor">¶</a></h3>
<p>I have also managed to learn where the QuickBooks log files are kept, open QuickBooks, then F2, then F3, this brings your to a developer menu. This was essential to finding the source of the bug, and I am relieved I did not have to do a full reinstall. I apologize for the inconvenience.</p>
<p>UPDATE: I had to do a full reinstallation of QuickBooks, however this was done after the ALThplt-2 crash and was migrated over to Windows 7.</p>
<a name="Useful-Links"></a>
<h3 >Useful Links:<a href="#Useful-Links" class="wiki-anchor">¶</a></h3>
<ul>
<li><a class="external" href="http://support.quickbooks.intuit.com/support/Articles/SLN40510">http://support.quickbooks.intuit.com/support/Articles/SLN40510</a> (Intuit Support for freezing Company files)</li>
<li><a class="external" href="http://support.quickbooks.intuit.com/Support/Articles/SLN42911">http://support.quickbooks.intuit.com/Support/Articles/SLN42911</a> (Intuit support for Company file not opening)</li>
<li><a class="external" href="http://support.quickbooks.intuit.com/support/networking/nettool.aspx">http://support.quickbooks.intuit.com/support/networking/nettool.aspx</a> (Intuit Network Diagnostic Tool)</li>
</ul>