Email to pro1040@home.com
Bob
Parrish CPA, P.C. HOME
(941) 387-0926 ~ It Is:
Introduction
Objectives
Your Questions
What You Will Need
Warning
Intro Summary
Related Information
*Plain English Explanation
Object Restated
Why or How It Works
Alternatives
Cost V. Benefit
Other
Reserved
*Tech Analysis & Citations
Commentary
Law
Regs
Cases
Revenue Procedures
Revenue Rulings
Private Letter Rulings
*TAX KILLERS
Title 1
Title 2
*COST KILLERS
Title 1
Title 2
*PREPARE
FOR ADVISER
Entrance Interview
From Your Other Business, or Financial Records
From Corporation or Organization Records (meetings, etc.)
*DO IT YOURSELF
Action
Checklist - What To Do
PRINT ALL THE REQUIRED DOCUMENTS
OBTAIN THE STANDARD WORKPAPER FORMS NEEDED
FINAL STEPS
*FINANCIAL ACCOUNTING
Financial
Statement Presentation
Notes
to Financial Statements
How to
Make Entries
What
Kind of Records to Keep
Bookkeeping
Methods - Cash, Accrual and Other
How the
Business Entity Affects the Recording
*COMPLIANCE
Title 1
Title 2
*ALERTS - DANGERS
Action Checklist
Alerts
& Dangers - Risks
Asset
Protection
Your
Defense
*TOOLS
Title 1
Title 2
*SAMPLES
Title 1
Title 2
*REQUIRED REPORTS
Title 1
*CHECKLIST FOR DEPLOYMENT
Title 1
*CHECKLIST FOR MONITORING
Title 1
*INDEX
pro1040 and Consulting OnLine are ©
Excel - Placing Pathnames in Footers
Preface ~ Client Letter - What this idea is about
Dear
Client:
When one prints a spreadsheet, printing the location of the computer file at the bottom of the paper in a non-obtrusive manner will tell you where to locate the spreadsheet on the computer without consuming your time.
Learning Objectives (What You Asked) ~ Your Questions: The following questions will be answered
This Topic OBJECTIVE is or What it Does
What You Will Need
| You Will Need | What or How Much? |
| Time | |
| Materials or Tools | |
| Library | |
| Who This Applies To & Industry Type | |
| When To Do This | |
| Special Circumstances or Warnings | |
TOP
Engagement Status Letter ~ WARNING!
You have not engaged Bob Parrish CPA PC, Bob Parrish CPA, pro1040, Consulting on line, any related parties, or the ISP to perform any services for you or offer you advice. This entire site is for educational or informational purposes only. You are not to use the forms, concepts, strategies, or knowledge without assistance from a professional. The author, the corporation, the ISP, Bob Parrish CPA, Bob Parrish CPA, P.C. or other parties related to those or this site do not guarantee or warrantee in any manner the suitability, usefulness, accuracy, timeliness, or results of any portions of this site, nor the links contained in this site which link to other areas. At times, information is taken from other sources and is believed to be accurate, but no verification or confirmation is performed. Furthermore, if any federal or state law invalidates a portion of this disclaimer, the other portions still apply. In addition, any allegations or actions are restricted to arbitration only and must be arbitrated by the Better Business Bureau in Sarasota Florida. Reading of these pages constitutes complete acceptance and agreement with all disclaimer provisions on all pages of this site. ....... Thursday, February 22, 2007 11:44 AM
Summary
| Poor old Sue Started a set of books anew without reading these lines few and now Sue is in a Stew |
Related Information
-
A few closely related topics & pages From Bob Parrish CPA PC (left-click this to expand it):
Plain English Explanation
Object Restated
Why or How It Works
Alternatives
Cost V. Benefit
Other
Reserved
Your Answers
This Topic OBJECTIVE is: What it does Explanation of this topic and how it may affect you (for how it may affect you also refer to : Financial Accounting: Bookkeeping & Financials ~ Compliance - What is required for protection, defense, etc. ~ Alerts & Dangers)
Start of Plain English Section
Why or How it works - Both Sides of the Equation and Examples:
For a more technical method jump to the Technical Analysis Section
When you print a worksheet in Excel 97 or Excel 2000, the header or the footer can include both the name of the worksheet and the name of the workbook. However, Excel does not provide a code for printing the full path (file location) of the workbook within the header or footer.
Using a small Microsoft Visual Basic® for Applications procedure (or macro), you can include the full path and file name in any section (left, center, or right) of either the header or footer. Of course, since you want to include the full path, the workbook must be saved to disk before you use the macro.
The following macro adds the current path and file name to the left footer of the active worksheet. The workbook must be saved before you can add any path information to the footer.
Sub UpdateFooter()
ActiveSheet.PageSetup.LeftFooter =
ActiveWorkbook.FullName
End Sub
To add the path and file name to the center or right section of the footer, change LeftFooter to either CenterFooter or RightFooter in the code. To add the information to the header, use LeftHeader, CenterHeader, or RightHeader.
To Create This Macro
Press ALT+F11 to start the Visual Basic Editor, and then click Module on the Insert menu. Enter the code from above, and then switch to the worksheet where you want to insert the path and file name. Run the macro (on the Tools menu, point to Macro, and then click Macros; the name of the macro is UpdateFooter), and then click Print Preview on the File menu to view the printout on screen to see if the path is in the correct location.
Note To make this macro available for any workbook you have open, you can assign it to a toolbar button. For more information about running a macro from a toolbar button, type add a macro to a toolbar in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.
Start of Plain English Section
Comparisons
Contrasts
Start of Plain English Section
Cost v. Benefit Analysis ~ Its Value
Start of Plain English Section
Other
Start of Plain English Section
Reserved
Start of Plain English Section
Technical Analysis and Explanation
Commentary
Law
Regs
Cases
Revenue Procedures
Revenue Rulings
Private Letter Rulings
Commentary
The following macro adds the current path and file name to the left footer of the active worksheet. The workbook must be saved before you can add any path information to the footer.Sub UpdateFooter() ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName End SubTo insert a Visual Basic module into a workbook in Microsoft Excel versions 5.0 and 7.0, click the Insert menu, point to Macro, and click Module. In Excel 97 for Windows, press ALT+F11 to start the Visual Basic Editor; then, click Module on the Insert menu.
Before you run the macro, switch to the workbook and the sheet for which you want to display the path in the footer. After you run the macro, the footer should contain the complete path and file name of the workbook.
Alternative Method for Excel 97
You can also use the BeforePrint workbook event to run a Sub procedure that adds the current path and file name to the left footer of the active worksheet before the workbook is printed. The workbook must be saved before you can add any path information to the footer. To create the Sub procedure in the active workbook, follow these steps:- Press ALT+F11 to start the Visual Basic Editor.
- In the Project Explorer window of the Visual Basic Editor,
double-click ThisWorkbook in the current project.
This opens a module for code that is associated with the workbook.
NOTE: If the Project Explorer window is not visible, click Project Explorer on the View menu.
- In the Object list for this module, click Workbook.
- In the Procedure list for this module, click BeforePrint.
- Enter the code so that the Workbook_BeforePrint procedure
resembles the following:
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName End Sub - On the File menu, click Close and Return to Microsoft
Excel.
NOTE: Before printing, make sure to save the workbook or the entire path and file name will not appear.
Using Ampersand (&) in the File Name
In Excel 7.0 and later, if the file name contains an ampersand (&), it may not display correctly. This is because Excel treats the ampersand as a special character in the header and footer. To display an ampersand in the header and footer, repeat the ampersand twice (&&). To do this in the macro, use the Replace function in Visual Basic for Applications:Sub UpdateFooter()
ActiveSheet.PageSetup.LeftFooter = Replace(ActiveWorkbook.FullName, "&", "&&")
End Sub
REFERENCES
For more information about the LeftFooter property, activate a Visual Basic module, click Answer Wizard on the Help menu, and type:
Tell me about the LeftFooter property
Start of Revenue Procedures Section
Start of Private Letter Rulings
Tax Killers
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
This is about Activity Based Taxplanning - maximizing deductions, minimizing cash outlay and maximizing the amount of cash retained and the net worth. Activity Based Taxplanning (ABT) is a methodology developed by Bob Parrish CPA, that assists people with the tax issues by focusing on the activity (or actions - events) that are being undertaken or contemplated (or have already taken place). The, research is compiled from the myriad of sources to help you complete the activity with the least tax cost, while maintaining compliance the tax laws, other laws and regulations and place yourself in a position to protect your objectives.
Tax is a subject that many view in order to cut costs. Taxes are a cost just as any other cost. It happens this cost is somewhat intangible and is defined by legislation without a tangible item to view and control. The money is spent and the control of the expenditure is more appropriately administered by someone trained in the law.
Cost Killers
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
Management Info Sys, Decision Support Systems, Activity Based Management and Costing, Cost Accounting)
Prepare for Your CPA or Attorney (or prepare for doing this yourself)
Entrance Interview
From Your Other Business, or Financial Records
From Corporation or Organization Records (meetings, etc.)
About the Preparation Procedures
If you have decided this task must be done, the first procedure is to be certain you have all the facts important to this topic. So that you may know the value, to you personally, of this topic you must have facts of your circumstances. So that you may comply with applicable rules, you must have all the facts. Factual research is time consuming and if not performed wisely will be very expensive if not performed properly, and thoroughly. IF you decide to make this a do-it-yourself project you should seek the advice of a professional qualified in your jurisdiction to assist you with defining important information and then to overview the information you have gathered.
What to gather - an Organizer and Prepare for your CPA, Attorney or Financial Adviser
Organizer
From Your Other Business, or Financial Records
From Corporation Records or Organization Records (meetings, etc.)
Start of Preparing For You CPA Section
Do It Yourself - Forms Required to Be Filed, Checklists, Etc.
DO
IT YOURSELF
Action
Checklist - What To Do
PRINT ALL THE REQUIRED DOCUMENTS
OBTAIN THE STANDARD WORKPAPER FORMS NEEDED
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
How to do this - What to Do
GENERAL SETUP & STARTUP
PRINT FORMS AND DOCUMENTS NEEDED
PRESENTATION STANDARDS
STARTING - FIRST THINGS FIRST, OBTAIN WHAT YOU NEED
OBTAIN THE ORGANIZER AND BE CERTAIN ALL INFORMATION IS AVAILABLE
OBTAIN AND SORT THE INFORMATION
OBTAIN THE STANDARD WORKPAPER FOLDER SETUP
OBTAIN THE STANDARD PRESENTATION LAYOUT
OBTAIN & OPEN ALL STANDARD DOCUMENTS OR WORKPAPERS
OVERVIEW & BECOME FAMILIAR WITH THE ENTRANCE INTERVIEW FORM
OVERVIEW THE LIST OF INFORMATION AND CLIENT OR BUSINESS RECORDS NEEDED
START THE REQUIRED COMPUTER PROGRAMS
OBTAIN THE CHECKLISTS IF NEEDED AND WORK ON THE JOB BY EACH TYPE OF ACTIVITY OR EVENT
OBTAIN THE STANDARD WORKPAPER FORMS NEEDED
LIST OF THE STANDARD FORMS AND W/P NEEDED
OBTAIN THE DOCUMENTS FOR THIS JOB
PLACE BLANK FORMS IN THE CORRECT SEQUENCE
GENERAL & FOR ALL JOBS
Instructions for finalizing and completion - for example instructions for the mailing of forms to the IRS
Actions Checklist
Report Cover Letter
Required Documents and attachments
DOING THE WORK
PRINT ALL THE REQUIRED DOCUMENTS OR MAKE COPIES AS NEEDED
DETERMINE THE CORRECT PRESENTATION STANDARD TO USE
ENGAGEMENT LETTER AND DISCLAIMER
PRESENTATION IN GENERAL
WHAT THE ENGAGEMENT IS LIMITED TO
WHAT SERVICES WERE PERFORMED
HOW THIS HELPS & BENEFITS
4 WAY TEST APPLICATION
Is it the TRUTH
Is it FAIR
Will it build GOODWILL and BETTER FRIENDSHIPS
Will it be BENEFICIAL to all
OVERVIEW THE WORK
BEFORE FINALIZING THE WORK PROCESS CONSIDER THE FOLLOWING
Compliance
Paying Bills or other events
The professional should perform functions the client does not have time for
The professional should perform necessary functions the client staff does not have training for
Reduce Costs
Reduce Risks
Setting Goals or objectives
Setting methods for monitoring
Setting dates, methods & procedures for follow-up
Setting guidelines for defining when variances from the guideline warrant policy or procedure changes
Identify the policies or procedures that need to be changed to accomplish the goal or objective
FINAL OVERVIEW BEFORE THE JOBS IS ENDED & CLOSED
LOOK AT THE ORIGINAL QUESTION - has it been answered, were more questions added?
THE ANSWER - limit the answer to a short paragraph of about 7 sentences. Did this solve the issue? The ANSWER is not considered the SOLUTION
THE SOLUTION - understand the objective or goal and restate it. Were the goals met? What might prevent obtaining the goals. Do the benefits outweigh the costs? Reduce Costs? Reduce Risks? Setting Goals or objectives:
Setting methods for monitoring
Setting dates, methods & procedures for follow-up
Setting guidelines for defining when variances from the guideline warrant policy or procedure changes
Identify the policies or procedures that need to be changed to accomplish the goal or objective. State Remedial Solutions and Preventive Solutions.
ACTIONS - checklist, calendar, columnar presentation showing separate columns for Client, CPA, Broker, Bookkeeper, Lawyer, Insurance Agent, etc.
COST v. BENEFITS ANALYSIS
PROPOSAL
FACTS DISCOVERED & USED
COMPUTATIONS & REPORTS
TECHNICAL ANALYSIS WITH CITATIONS AND AUTHORITY
FORMS - agreements, contracts, trusts, tax forms, financial reports, management information reports, policies or procedures
REQUIRED ATTACHMENTS
Overview - look at the steps required and the steps performed. Are there unusual items? Are there exceptions or adverse results of the procedures performed? Find resolutions for all unusual or adverse items.
Compliance - has compliance "substantially" been met. That is no "material" adverse results?
Math Check
Proof and spell check
Theory & overview by someone not performing the procedures
Close the case and archive it.
Financial Accounting - Bookkeeping and Financial Statements
Financial Statement Presentation
Notes to Financial Statements
How to Make Entries
What Kind of Records to Keep
Bookkeeping Methods - Cash, Accrual and Other
How the Business Entity Affects the Recording
Financial Statement Presentation
Back to Start of Financial Accounting: Bookkeeping & Financials
Back to Start of Financial Accounting: Bookkeeping & Financials
Back to Start of Financial Accounting: Bookkeeping & Financials
Back to Start of Financial Accounting: Bookkeeping & Financials
Bookkeeping Methods - Cash, Accrual and Other
Back to Start of Financial Accounting: Bookkeeping & Financials
How the Business Entity Affects the Recording
Sole Proprietor
Corporation - C & S
Partnerships - General, Limited, Limited Liability Company, Registered Limited Liability Partnership or Company
Trusts
Tax Exempt
Back to Start of Financial Accounting: Bookkeeping & Financials
Compliance Requirements - Requirements, Defense, Protection, Etc.
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
Compliance Checklist
Back to Start of What is required for protection, defense, etc.
Alerts and Dangers
Action Checklist
Alerts & Dangers - Risks
Asset Protection
Your Defense
Title 5
Title 6
Back to Start of Alerts & Dangers
Back to Start of Alerts & Dangers
Back to Start of Alerts & Dangers
Back to Start of Alerts & Dangers
Tools - Spreadsheets - Documents - Checklists - Organizers
TOOLS
Spreadsheets & Math
Spreadsheets & Computations
Back to Start of Spreadsheets & Math
Sample Agreements - Trusts - Etc.
Title 1
Title 2
Back to Start of Contracts, Trusts, etc.
Required Reports
Title 1
Title 2
Back to Start of Reports Required
Checklist for Deployment
Title 1
Title 2
Checklists for Deployment
Back to Start of Checklists - Deployment
Checklist for Monitoring
Title 1
Title 2
Back to Start of Checklist - Monitoring
Index
Title 1
Title 2
Click on the text to expand or collapse the outline
-
Analyses
-
Plain English Analysis - Your Answers
-
-
Do It Yourself
-
How To Do This
-
Increase Wealth
-
Information Sources
-
Introduction
-
Procedures
-
Tools
Contact Information
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
