Monthly Archives: July 2014

External access to my home PC

Posted on by
1

So I’ve never bothered to get a static IP address from my ISP.. this makes it a bit of a challenge when wanting to access files from work, that are sitting on my home pc.

However.. I do have a website hosted elsewhere..
So what I have done (actually for about 15 years now).. is run a little scheduled task on my home PC, that obtains it’s IP address, creates a little web page, and FTPs that page to the website. Then, I can access the website and link to my home PC. The odd time I want to make a slight change to this, I have to relearn what I’ve done.. So I’m writing it up here finally…in case I actually remember to check here 😉

Its changed a little over the years.. pending my ISP, and changes to how I connect to them. These days I have a router connected to them.. So my home PC never actually gets the external IP address assigned.

SO.. it takes a mapping in my router to forward the requests to the static LAN IP, and it also take a little trick to find out what the external IP address is..

Here is the script I use to do that:

set "header=^<head^>^<body^>^<a href=http://"
set "footer=^>my place^</a^> update at: %DATE% %TIME% ^</body^>^</head^>"

FOR /F "tokens=1 delims=" %%A in ('call wget -q -O - http://myexternalip.com/raw') do SET ip=%%A

echo.%header%%ip%%footer% > linkhome.html

FTP -v -i -s:ftpscript.txt

The website I use has changed a couple times (they seem to come and go).. but this one is working great right now (myexternalip.com).
I also use wget, which is just a handy thing to obtain websites as a file for parsing.

The only other thing is serving it up. For this, I use Apache. I set it up to have an alias to the folder I want to allow access to, and enforce authentication based on a specific local user.

The funny thing is that trying to access it within my LAN (ie. from my other PC), won’t work using the external IP address.. (it will if I just use the local machine name / lan ip address).. but it works fine when coming externally.

corporate tax related bookkeeping entries

Posted on by
Reply

Here is a good blurb I found which follows what I’ve been told as well..

Hi,

I will assume that a bookkeeping entry was made each year … once you had calculated the tax refund due as follows:

Dr. (decrease) Corporate Income Tax Payable (a current liability on your balance sheet)

Cr. (decrease) Income Tax Expense (an expense account on your income statement)

Any corporate income tax installments made do not affect your income statement. Installments are NOT income tax expenses … so I will also assume that when your corporate income tax installments were made, bookkeeping entries for each year were made as follows:

Dr. (decrease) Corporate Income Tax Payable (current liability on your balance sheet)

Cr. (decrease) Cash in Bank (current asset on your balance sheet).

I am also assuming that if the Corporate Income Tax Payable account was a debit balance, at the appropriate year-end, the amount would have been reclassified by your accountant to Corporate Income Tax Refundable, a current asset account, as part of your year-end adjusting entries … and reversed on January 1.

Once you receive your income tax refund, you would book the following entry to clear your payable account:

Dr. (increase) Cash in Bank ( a current asset on your balance sheet)

Cr. (increase) Corporate Income Tax Payable (current liability on your balance sheet)

Cr. (increase) Interest Income (income account on your income statement)

If you have any working papers, you will probably have an analysis of your corporate income tax payable by year. It is in your working paper file that you will allocate the refund to the appropriate years.

That said, I like to book the actual refund entry by year with good comments so that it is clear to anyone reviewing the general ledger what is happening in the account.

For all the bookkeeping entries, I like to make good memo notes about which year the entry pertains to.

Taken from http://www.bookkeeping-essentials.com/corporate-income-tax-refund-journal-entry.html

website admin pains

Posted on by
Reply

so it was ages since the last time I administered one of my sites.. and of course i couldn’t find passwords, etc.

i was using joomla as the CMS.. had to even find out that ‘admin’ was the default administrator user

found good tips for setting the password through a backdoor at:
http://www.dart-creations.com/joomla/joomla-tips-and-tricks/25-forgot-your-super-administrator-password.html

for that even though, i had to find the database name / username and password for that.
with go daddy being the host, they have a mySQL tool, and then from the list of databases, i could choose ‘details’, and within that, it gave me the username, and a place to reset the password.

after doing that, i got into the database, and altered the admin password for joomla.

the login worked, but then an error from joomla trying to access the database.
turns out it needs the right database password stored in the configuration.php file on the root of the website.

So i looked at that using go daddy’s file manager, and sure enough in there i found the spot, and could see what the old password was for the database.
i updated that file to the new password..

gave the site a while to refresh it’s cache.. and then everything worked..

i’ll likely need all the above again.