Can't find UK in USPS' Click-N-Ship? or when using Etsy labels?

Content Go To Great Panes, Kathryn Maloney ©2012
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

I see folks asking about this pretty often so I thought I’d put up a quick post:

If you can’t find the “UK” or United Kingdom as a destination in the free USPS program “Click-N-Ship for Business” (formerly the USPS Shipping Assistant) that we use to print our First Class International labels, the online USPS customs form maker, Click-N-Ship online label service (for Priority & faster) or when you’re using Etsy’s label feature, it’s because USPS uses the “Great Britain & Northern Ireland” instead:

For UK use Great Britain & Northern Ireland


USPS’ designation of Great Britain and Northern Ireland includes:

England
Scotland
Wales
Northern Ireland
Guernsey
Jersey
Alderney
Sark
the Isle of Man

See it here on the USPS website.

Hope that makes your next UK mailing a little less stressful. 🙂

Go To Great Panes, Kathryn Maloney ©2012

What can't I mail?


Go To Great Panes, Kathryn Maloney ©2012
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Do you know what you can and can’t mail through the US Postal Service?

The USPS guide for prohibited items in domestic packages can be found here:

Can You Mail It?
(https://www.usps.com/send/can-you-mail-it.htm)

Besides the prohibited items listed there, if you click the “Hazmat” tab there’s also restricted items that include perfumes, nail polish and another dozen items.

There’s also a tab for showing you size restrictions and one for “Special Handling” which is about shipping live animals.

Shipping plants or other perishables?
Shipping knives?

You’ll need the more detailed explanation–see this USPS publication:

Publication 52 – Hazardous, Restricted, and Perishable Mail
(http://pe.usps.com/text/pub52/welcome.htm)

For more shipping tips see our main “Shipping” page–see the gold links on the right or click here:
Shipping Basics

Go To Great Panes, Kathryn Maloney ©2012
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

a href=”http://www.gotogreatpanes.com” target=”_blank”

Auto-sum: Adding Up Your Totals

GoToSupplies on Etsy
Visit our Etsy shop:
GoToSupplies

Go To Great Panes, Kathryn Maloney ©2012
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

One of the handiest tools in the box for a small business (and personal) finances is the auto-sum feature on spreadsheet programs.

Many use Microsoft Excel for their spreadsheets (need help with that? See here: http://www.gotogreatpanes.com/blog/?p=858) but other programs have that feature too.

If you don’t have software on your computer to create/edit spreadsheets, Open Office is great free program you can download–it has several sections:

Writer: word processor
Calc: spreadsheets
Impress: multimedia presentations
Draw: creates images as simple as diagrams and as complex as 3D illustrations
Base: databases
Math: mathematical equations

Calc is the one to use for spreadsheets & CSV files. I’ve also used the word processor, but haven’t tried the other parts–I’d love to hear how you like them!

Open Office Calc

If you just want to see what the sum is temporarily, you can highlight an entire column by clicking the letter above the column–Calc will show you the sum of all the items in that column in the footer of the window (I’ve shrunk it down to keep it easy to see here, but the window normally fills all/most of the screen):

Click images for a larger view

Before:

Click column header (red arrow):

Sum shows (red arrow):
(The sum won’t be exactly in the right-hand corner of the program, just in the footer. I’ve shrunk the whole thing down for easy viewing in the small images here.)

You can also just highlight a few cells and it will do the same, no need to do the whole column if you want to total only certain entries–even if the entries aren’t next to each other:

Open Office Calc’s Autosum

If you want to add the column up and save the total for quick reference later (without having to reselect the column)/to see how it changes when you add/remove/edit the numbers, you can use the auto-sum button to insert the total into the spreadsheet.

Highlight what you want to add up plus one extra blank space below it, and click the blue “E” (see the red arrow):

and the sum will be put in the extra box; in this example $14.95 is the total:

Go To Great Panes, Kathryn Maloney ©2012
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.