Waching daily Oct 25 2018

Hello, and welcome to the Philadelphia College of Osteopathic Medicine REDCap tutorial.

In these videos, we'll go over some basic policies and procedures, jump into REDCap,

walk through how to create a project, special features, how a survey works in REDCap, and

how to do a longitudinal study using REDCap.

Let's get started!

At the Philadelphia College of Osteopathic Medicine, any PCOM faculty, staff, or resident

with a pcom.edu email address can request and create a REDCap user account.

PCOM students may create a REDCap account through a faculty or staff sponsor.

REDCap users can create projects for a variety of purposes, including longitudinal research

projects, qualitative projects, and simple surveys.

All research projects involving human subjects must receive IRB approval as per PCOM policy.

You do not need IRB approval to begin creating your project.

However, you must submit your IRB approval before your project moves to production and

you begin collecting data.

To use REDCap, the first step is to watch these tutorial videos and complete the quiz.

Upon passing the quiz, a REDCap administrator will create an account linked to your PCOM

email credentials.

To log in to REDCap, use the credentials sent to you by a RedCap administrator.

You may change your password at any time.

After your account has been created, you'll be ready to create your REDCap project.

A REDCap project database has multiple stages.

The first stage is development.

At this stage, you create your project and design your database or survey forms.

You'll want to test these as much as you can, to make sure that you're collecting all necessary

information, and that the flow of information works well for your project.

You're also going to want to make sure that any special things you do, like branching

logic or calculated fields, are working correctly.

There are a few useful tips to remember when you're creating your project database.

The first tip is that in each variable the subject or record ID must be the first variable

on the first form.

This ID is unique to each record.

Second, variable names can only contain lowercase letters, numbers, and underscores.

You can't use spaces in these fields.

To make data entry as easy and clean as possible, use drop down menus and validated text fields.

This step will save a fair amount of time and headache, because you won't need to

look up a value or spelling.

You can use field notes to indicate required units or formats.

Group similar variables together on separate forms, and keep the forms fairly short.

There are two reasons that you want to do that.

One is that it's easier for people to enter many short forms as compared to one incredibly

long form.

The other reason is that REDCap forms aren't saved automatically.

They are saved when you click the Save button at the bottom of the form.

If you have a very long form, then you run the risk of a technical error occurring, or

that the data entry person's REDCap session might time out before they save.

You'll want to identify all potential protected health information, so that you can strip

away that data before exporting.

We recommend that you run a quick check on the data dictionary to see if it meets general

best practice standards.

You can find more information about this recommendation on our RedCap Guide.

Once you have everything completely designed and you've tested it multiple times, you'll

be ready to submit a request to move your REDCap project to production by emailing a

PDF of your IRB approval documentation to redcap@pcom.edu.

Finally, REDCap is capable of doing calculations.

But it's not designed as a statistical tool.

Only include calculations in your REDCap database if they're necessary.

Otherwise, handle calculations after the data has been exported to a package that is designed

to run statistics, such as SAS, SPSS, STATA, or R. This will lead to cleaner analysis,

plus your statistician may rerun any calculations for verification.

Once you have everything completely designed and you've tested it multiple times, you'll

be ready to submit a request to move your REDCap project to production by emailing a

PDF of your IRB approval documentation to redcap@pcom.edu.

After your project's been moved to production, you'll be ready to start collecting data.

When you have all your data, you'll be ready to export your data for analysis.

Once you have started collecting data in a project moved to production, any critical

changes made to your project will require further review by a REDCap administrator.

REDCap will automatically approve most changes.

If your proposed changes could harm your data, REDCap will forward your request to a REDCap

administrator who will verify that you want to move forward with the changes.

This measure is to protect the integrity of your project.

Ultimate liability for any issues that may occur lies solely with you, the researcher,

and your team.

You can archive projects, which removes the project from your list of project databases.

Your project can be returned to production at any time, and it will be stored on the

servers for at least seven years.

Archiving projects removes some clutter from your REDCap homepage.

If you decide to publish your work, we ask that you recognize REDCap in the publication.

You can see how to cite REDCap by going to our REDCap guide.

If you have any questions or would like to schedule an appointment with a librarian,

contact us at redcap@pcom.edu.

We aim to respond within 2 business days.

Next, we'll look at how to log in to REDCap and how to begin creating your project.

For more infomation >> REDCap Tutorial Video 1: Background Information - Duration: 6:19.

-------------------------------------------

Video Pengenalan Diri LMCR 1052 - Duration: 2:32.

No pain, no gain.

You'll definitely learn something new

after being suffering on it. Hi everyone, I'm Ong Wei Tat from Penang,

the pearl of Orient.

I'm currently pursuing my tertiary education in UKM, with program Bachelor of

Occupational Therapy (Hons.). There are five members in my family:

my dad, my mom, me myself and two younger brothers.

My dad own a mini market with my uncles

while my mom is a housewife. As the eldest son in my family, I have to always take good

care of my two younger brothers. I'm graduated from Chung Ling high school with

8A's in my SPM and Perak Matriculation College with a pointer of

4.0 in my PSPM.

In order to become a qualified occupational therapist, I have to update myself with

all the current issues on this field. Therefore I like to spend most of my

free time in library to study those journals. Besides I found that the

library can give me a sense of calmness, therefore I love to study in this

library. I found that study in library can make my revision more efficient.

Apart from academic, I'm also actively involved in several extra-curricular activities

In 2015, I've participated the 5th International

Students Camp organized by Chung Ling High School. This students camp is joined by

students from various countries such as Indonesia, Taiwan, Singapore, China and

many more. Besides I've also held several positions in clubs.

I was the Shift Leader of the Board of Librarians, Secretary of Editorial Board

of School Bulletin and the Chairperson of Aquarium Society.

I was the mentor of biology subject in my matriculation's practicum. And currently, I'm

the class representative of my program. Thank you for watching my video. Feel

free to contact me if you have any doubt. Thank you and have a nice day!

For more infomation >> Video Pengenalan Diri LMCR 1052 - Duration: 2:32.

-------------------------------------------

REDCap Tutorial Video 4: Online Designer - Duration: 12:19.

Let's start by creating a database.

The majority of your database creation will be done in the Online Designer.

Here you have a list of all the instruments or forms in your project.

REDCap uses the terms instrument and form interchangeably.

You can hit the create button to create an instrument from scratch or you can use the

import button to pull in an instrument from the REDCap shared library, which is a collection

of instruments put together and monitored by one of the groups in the REDCap consortium.

Any instrument that has a red star next to it is a validated instrument that has gone

through a significant screening process to ensure that it is both free for use and that

it has been translated accurately from paper to electronic format.

If you're using a validated instrument that is relatively common and open to public use,

you might want to check the REDCap library before you create it so you don't have to

reinvent the wheel.

You can also upload an instrument from another project.

Once you've created your instrument, you can make changes to it by clicking on the title.

To create a new field, click on the "Add field" button.

To edit an existing field, click on the pencil icon.

There are many types of fields that you can use in a REDCap project.

Use a text box to display free text as one line or a notes box to display free text as

several lines.

They both have a 65,000 character limit.

Calculated fields do calculations.

There are three types of multiple choice questions, yes/no and true/false questions, an e-signature

field, a field to upload files, a slider field, a field for descriptive text to write out

instructions or add media, and section headers that break up the text.

The field label is where you type out the question as you want it to be seen on the

data entry form or survey.

For example, a field label might be "Please tell us your age" or "How many packs of cigarettes

do you smoke in a week," or "When were you diagnosed with diabetes?"

The variable name is a short, alphanumeric name that you'll use to identify your field

on the back end when you're doing analysis and is how REDCap identifies your variable

as something unique.

This should be something relatively short and meaningful enough that it makes sense

when you do your analysis.

You also have the option to validate your text fields.

If you want people to enter words in your text field, you won't need to validate it,

but for most other kinds of text fields you will.

For example, if you're using dates you'll need to note the date format or the date/time

format.

You can validate fields as email; integers only; a number, to multiple decimal places;

a phone number; a time; or a zip code.

There are two reasons you validate a field.

One reason is to prevent data entry errors, since a validated field won't accept a different

type of data.

The other is to ensure fields are exported appropriately.

For example, if a numbers field is not validated then it will export as text, meaning it would

sort as 1-10-11 instead of 1-2-3-4-5.

The validation would then have to be manually changed later.

Validating fields correctly in the beginning saves a lot of time and effort.

So, as this is an age field I'm going to validate it as an integer.

The minimum and maximum provide an expected range for the field.

I expect my participants to have an age between 18 and 80.

These are soft validations, meaning people can enter other values, but they'll get a

quick popup letting them know they might need to check their answer.

You can make a field required by selecting "Yes" to the Required?

option under Validation.

On a data entry form filled out by a researcher, there will just be a prompt that this field

has been left blank.

On a survey form filled out by a participant, participants will not be able to move on until

they provide an answer in the field.

You can mark the field as containing potentially identifying information, like name, birthday,

or address.

You can give it a custom alignment, which just says where the box or multiple choice

answers appear in relation to the field label, and you can give it a field note, a small

textual reminder that displays underneath the field exactly like it does under the Field

Note field.

For multiple choice fields, you'll select which of the three multiple choice fields

you want: drop-down list, radio buttons, or checkboxes.

Give it a field label and variable name, then list all potential answer choices in the Choices

box with one answer per line.

If, partway through your study, you decide you want to add an answer choice you can do

so at any time.

However, you should not renumber answer choices.

If I want to add the choice "physical therapy," I should not insert the number in the middle

of my existing choices.

If I try to do that, anything that was biomedical sciences is now going to read as physical

therapy.

Anything that was psychology is now going to read as biomedical sciences, and anything

that was physician assistant is now going to read as psychology.

You should never recode your variables.

Instead, just assign the next number on the list.

The order of these coded choices doesn't matter; it just matters that they're unique and you

don't change it.

Another very common option for a multiple choice question is wanting an N/A or Other

answer option.

It's considered best practices in data circles to give them a big number, usually two or

three digits like 88 or 99.

This sets it apart from the rest of your answer choices.

If you have multiple choice questions that all have the same answer choice, you don't

have to type it out every single time.

Instead, you can go to "Copy existing choices" and find the example of the one that matches

how you want it to look and click use.

This way you keep your coding consistent across all your multiple choice fields, which helps

prevent errors when you're doing your analysis.

It can also save time.

Dropdown fields have one small difference compared to radio buttons or checkbox fields.

In the dropdown fields, you have the option to enable autocomplete for the dropdown, so

that as people are typing it tries to autocomplete the answer for them.

Next are slider fields.

Creating a slider field is done in the same basic way as all the other fields, with the

small difference that instead of displaying answer choices you provide labels for the

different points in the slider.

You do not have to put in labels, and you do not have to fill in all the label fields.

Slider fields are scored on a 0 to 100 scale, and you can choose whether the person entering

the information can see that number value.

Custom alignment can also be a little bit more interesting with slider fields because

you can make them horizontal, which is the default, or vertical.

Next, we have descriptive fields.

Descriptive fields have the same field label and variable name setup that all the other

fields do.

If you're using the descriptive field to provide instructions, you'd put them into the field

label.

You can use the descriptive field for file attachments.

Here, I have a picture uploaded and displayed inline so that it's automatically seen when

the page loads.

If I wanted to, I could change that to a link where participants can download the picture.

This is great if, for example, you want your participants to download a consent form.

You can also embed audio files that participants could listen to or download or you can link

to an external video, such as a YouTube video.

Doing this is easy- find the video, wherever it is hosted, and paste the URL in the "Embed

an external video" field.

Again, you can choose if you want it inline so participants can play it as they're filling

out the form or place it in a popup window.

If you select "Inside popup", participants click the "Watch video" button and they

get a popup window to let them play it.

The next kind of field is a yes/no field.

We actually recommend that you don't use the yes/no or the true/false fields, because the

choices are hardcoded with 1, Yes/0, No; or 1, True/0, False.

This assignment is common in data management, but researchers sometimes decide partway through

the project that two answer choices are no longer considered sufficient.

In that case, you have to go and change this to a multiple-choice field and may forget

the existing codes, meaning that what was yes is now coded no.

All of the no answers are lost, and you would have to start from scratch with the new yes

and N/A fields.

Therefore, to save yourself the time and trouble, start by creating yes/no fields as multiple

choice questions.

File upload fields are where a participant or data enterer can upload their own document.

These all have a field label and a variable name.

Similarly, the e-signature field is simply a field label and a variable name.

The final kind of field is a section header.

Section headers are yellow bars that help break forms into easily manageable chunks

and let people know what's coming up in the next group of questions.

These don't have a variable name to worry about, only an optional field label.

The other thing I want to show you here is how I've used a little bit of HTML to change

the color of the text and to center it.

You can use HTML in different kinds of REDCap fields, such as field labels, the answer choices,

or in survey invitations.

"You can find HTML coding for PCOM brand colors together with links to HTML coding

for other colors on the REDCap guide at libguides.pcom.edu/redcap."

Those are the most basic features of the online designer.

We'll go over some of the more advanced features in other videos.

For more infomation >> REDCap Tutorial Video 4: Online Designer - Duration: 12:19.

-------------------------------------------

Early Afternoon Video Forecast - Duration: 0:28.

For more infomation >> Early Afternoon Video Forecast - Duration: 0:28.

-------------------------------------------

REDCap Tutorial Video 3: Project Setup Page - Duration: 9:13.

Let's review the four main pages you'll use over the course of your REDCap project.

When you're in production, the landing page will be the Project Home page.

This has quick links to a lot of backend tasks, such as exporting data, running reports, and

managing users.

The Other Functionality page has a lot of useful features that you might use over the

course of your REDCap project.

For example, you can use this page to make a copy of your project.

This makes an exact duplicate of the project, including users and project records.

You can use this feature if you're making a second project that is very similar to your

first project.

Instead of rewriting the project, you only have to make small modifications.

You can also use this to test out large changes in the project to see how they would affect

your data or to preview how the project would look before making changes to your main project

database.

You can download a backup of the project as an XML file, including metadata for the project

setup, the data dictionary, and collected data.

You can also use these XML files when you're creating new REDCap projects.

Under Project Management you have three options: delete the project completely, erase all the

data in the project, or archive the project.

This moves the project off your list of My Projects so that it doesn't clutter the

page.

When your project's in production, you'll also have the option to move the project to

inactive status.

You can still run reports and export data, but you'll no longer be able to enter new

data into the project.

The Project Revision History page largely takes effect once your project is in production

mode.

Every time you make a change to your project in production mode, REDCap automatically saves

a copy of the previous data dictionary.

This way, if you no longer want the change, you can easily back track.

In the Online Designer, you can also create a snapshot of the project that will be stored

in revision history.

If you make large changes while in development, REDCap will have an earlier saved copy of

the dictionary so you can back track in case you overwrite something.

While your project is in development, your landing page is the Project Setup page.

In the Main Project Settings, you can enable surveys and longitudinal data collection within

the project.

You can also change the project title, purpose, and any additional project notes.

Design Your Data Collection Instruments & Enable Your Surveys will be covered in later videos.

Enable Optional Modules and Customizations allows you to add or remove some additional

features that you can use while you're in REDCap.

For example, by default all records are auto numbered, meaning REDCap will just assign

each record 1-2-3-4-5 unless you turn it off and tell it you want to number your records

manually.

You can also turn on repeatable instruments here.

Under Additional Customizations, you can set a custom record label--by default, the record

label is just the record ID, but you can also manually insert information.

In any record where the participant has supplied their first and last name, you can insert

the information from that field into the record label so you can easily find the participants.

If you want to have more than one unique field you can define that here, or you can order

records by a field other than the record ID.

By default, the field comment log and the data history widget will be enabled.

This allows you to better manage the data in your project.

You can also display a today-now button next to all date/time fields.

Set Up Project Bookmarks allows you to create quick bookmarks stored on the left-hand menu

that let you jump to pages either inside or outside of the project.

User Rights and Permissions are how you add and manage the users on your project.

To add a new user, go to the User Rights page and enter their REDCap username under Add

New Users.

If you don't know their exact username, start typing to see suggested users.

Then, click Add with Custom Rights to select their privileges and choose how long they

have access to your project.

Project Design and Setup, User Rights, and Data Access Groups privileges should only

be given to people who actually need those rights in your project.

Project Design and Setup allows people to modify the data dictionary and the general

design and setup.

User Rights is the ability to add and remove users from the project and to change what

individual users can do within the project.

Data Access Groups are similar to user rights, but on a group level.

Next, define what rights a user has for exporting data: no right, de-identified, remove all

tagged identifier fields, or full rights to export the full data set.

De-identified is the default option and means that all tagged identifier fields are removed.

Other privileges include the ability to use the calendar tool, import data en masse, look

at the file log, or access things stored in the file repository.

Next, you can give users access to the REDCap mobile app.

The mobile app is a completely separate application that does not give full access to REDCap.

It is designed to collect data offline that can be synced with your project later.

Next, you can give users the ability to create, rename, and delete records, and say whether

or not they can lock or unlock records.

If a record is locked, none of the information in it can be changed.

Finally, choose the data entry rights for each individual form in your project.

You can say that someone can't access a form at all, that they can only read it, or that

they can read and edit.

For surveys, you can choose if they can edit survey responses.

When you're done, click Add User.

If you have many people in your project who are all going to be doing similar things,

you can create a role, such as "data entry role", that has a specific set of rights.

Then, instead of having to add each person individually and check off all the boxes,

you can assign them to that role and everyone will have the same rights.

Data Access Groups are something that are largely used on multisite projects to create

a number of different groups.

Once assigned, they will only be able to see the data that those at their specific site

entered.

They will not be able to see the information for any other site to better manage project

access at each site.

Now, let's look back at the Project Setup page.

After you've set up your forms, customized your project, and added all your users, it's

important to test your project by adding practice records.

If you're using surveys, send out practice surveys to yourself or to your colleagues.

If you're using a longitudinal project, make sure that you've tried doing data entry in

all or at least many different events.

If you're working with other people on your project, have them test it as well.

They might be able to tell you if there's anything that will be a problem for them.

Finally, use the data dictionary checker on our REDCap guide to see if it meets best practice

standards.

Once you've tested your project thoroughly and are ready to move to production, click

on the Move to Production button.

You have the option to keep any data that you've entered so far or delete test records.

Once you hit the "Yes, move to production status" button, REDCap will send an email

to the administrators.

If your project requires IRB approval, we'll ask you to provide the IRB approval letter

for the project.

Once we have the form or if your project doesn't require one we'll move the project to production

and you'll be ready to begin collecting real data.

For more infomation >> REDCap Tutorial Video 3: Project Setup Page - Duration: 9:13.

-------------------------------------------

REDCap Tutorial Video 2: REDCap Login and Project Creation - Duration: 4:02.

When you first go to redcap.pcom.edu, your landing page is the REDCap home page.

Here, you can see a link to our REDCap LibGuide, which has lots of information about REDCap

accounts, REDCap policies and procedures, and all the tutorial videos.

Once you log in, you'll go to the My Projects page.

This is a list of all the projects that you have access to.

It provides basic information about each project, such as the number of records and fields,

type of project, and whether it's in production or development mode.

You can organize your projects into folders by using the Organize button.

Here you can enter a folder name and pick different colors to change how the folder

name displays on your list.

Then you can select it on the drop down on the right and say what projects you want to

put in the folder.

Once you click Close, everything will be in folders, and you can choose to limit or expand how

many projects you're seeing at any given time.

The Help & FAQ tab links to the general REDCap FAQ.

You can use ctrl+F to search for specific topics or find topics on the dropdown menu.

The FAQ is maintained by a REDCap Consortium committee and is kept up-to-date.

It's a great reference for a lot basic questions.

It's especially useful for things like calculations, branching logic, or piping where you might

have to use a specific syntax, such as the datediff calculation.

On the Training videos tab, Vanderbilt University provides videos.

These videos explain how to use REDCap, but we do recommend that you use our videos as

a general rule because our videos go over PCOM-specific policies and procedures.

On the New Project tab, you can create a new project.

You'll need to give it a title, a purpose, and specify a type of research when doing

a research project.

You can choose to assign the project to a specific folder.

Project notes are used to describe the purpose of the project and are only for your reference.

If it's your only REDCap project, you might not need to put anything in the notes.

But if you're making a major change to a project and you're testing a copy, use project notes.

The notes are useful for keeping track of your processes and procedures throughout the

different stages of your project.

Finally, you have the option to begin your project from scratch, upload a previous RedCap

project, or use a template.

Creating an empty project is self-explanatory.

To move a project from another university's REDCap to PCOM's REDCap, download the project

as an XML file and then upload using the Upload REDCap project XML file option.

This copies the data dictionary, the data, and project setup metadata.

You also have the option of using a template.

Feel free to play around with using the templates when creating a new REDCap project.

It's a great way to learn a little bit more about the system.

Once you've made your choices, hit Create Project, and it will take you to the project

setup page, where you can start building your new project.

For more infomation >> REDCap Tutorial Video 2: REDCap Login and Project Creation - Duration: 4:02.

-------------------------------------------

West Nile Virus Survivor Video with Korean Subtitles - Duration: 4:21.

For more infomation >> West Nile Virus Survivor Video with Korean Subtitles - Duration: 4:21.

-------------------------------------------

video clip - Duration: 6:28.

For more infomation >> video clip - Duration: 6:28.

-------------------------------------------

Amazon Accounting Simulation Video - Part 1 - Duration: 7:23.

Hey guys. Jerry Freedman here. It's my first video, my first LinkedIn video so

please go easy on me. The reason I'm making this video is because I work with

a lot of Amazon and e-commerce companies and I see a lot of the same common

mistakes. Many of them are back to the basics just simple incorrect accounting

practices. Some of them are a little bit more complex. So I'm creating this short

video series hopefully one to five minute videos just going through some of

the issues I've discovered and the resolution to these issues and how to

to correctly account for your Amazon activity. So on a basic level I'm

going start out, you can see I have ABC company balance sheet and income statement

here. Now it's very bare, I only left in the accounts as it relates to the Amazon

activity and for purposes of my example it is super super simplified. Just before

I start, if any of you have any questions or disagree, feel free to DM me or

comment on my post, and I'd happily answer your questions or just have a

discussion. Ok, so ABC company balance sheet as of

3/31/18......so they received a deposit of $95,000 let's assume mid-march they

received a deposit of $95,000. So ABC company's bookkeeper went ahead and

recorded $95,000 to Amazon sales income. The cost of goods sold was $65,000, I'm

gonna cover cost of goods sold in in a different video,

but for simplicity's sake, $65,000 gross profit $30,000. So you ask what is

wrong with that Jerry? The answer is that $95,000 on a

settlement from Amazon.... a $95,000 deposit is not ninety

five thousand dollars in sales. If any of you have experience in looking at a

settlement from Amazon, this $95,000, if you take a look at the

spreadsheet that it relates to, the settlement statement,

this can be ten thousand rows of all different transaction types. So in

reality the kind of transactions--and I sort of broke some of them out here,

there's many different kinds of transactions that can relate to selling

on Amazon, and what has to be done in this case is grossing up--I like to call

grossing up, essentially where this is just the net deposit $95,000 just on the net deposit but in reality sales were significantly

higher and then you have to record some of your selling expenses and cost of

goods sold which is another topic to-- a lot of business owners like to include

their cost of selling on Amazon in their cost of goods sold-- that's a whole other

discussion, but all that has to be broken out on the income statement. Additionally

we also have some balance sheet items that...although there may be money coming

in or money going out on the settlement, it doesn't necessarily mean it's income

and expense some of these can purely relate to balance sheet items and it has

to be treated correctly. So I went ahead and took the liberty of breaking things

out. Now this is my tab of how it should look. This $95,000 is a

lot more than just ninety five thousand dollars in sales and as you can see so I

broke things out on the P&L so really it was $115,000

in sales $5,000 in returns and refunds, so that brings us to

gross (net) sales of $110,000 your total sales

income now we have our cost of goods sold

$65,000 which again is another another discussion, and that's just the basic

cost of goods sold. But if you look over here I broke out some of the other

expenses on the income statement that relate to this Amazon settlement. So we

had $2,500 in Amazon delivery and transport fees

$7,000 in commission and selling fees, $4,000 in fulfillment and

warehousing, which brings us a total cost of goods sold of $78,500.

Now that brings us to a gross profit of $31,500 so you may ask: Jerry

gross profit was $30,000, why is it now $31,500? What happened to the

the other $1,500? The answer is that included in that settlement, Amazon-- again for

simplicity's sake.... not... we're not talking about recent events regarding sales tax

here, but on a basic level in the state that you're based out of, Amazon collects

sales tax for you if there are any sales to customers within that state. So what a

lot of businesses do is.....so Amazon essentially collects it for you then

remits the funds back to you and then it's your responsibility to remit that

to the state and file your sales tax returns. What a lot of people will do is

they'll include it in Amazon sales income or they will break it out on the

income statement, and then when they file their tax return...their sales tax

return they will record it as an expense on their.... income statement thus

netting it down to zero. But in reality that's a balance sheet item because it's

not income. It's not an expense. t's money that is owed to the state so it

shouldn't even be hitting your P&L. So that $1,500 difference went to sales

tax payable on the balance sheet, and now when you look at the the income

statement you have a better idea of the activity and what occurred as it

relates to this $95,000. Now Amazon typically pays that every two weeks so

imagine if you broke out every settlement correctly in this fashion and

then you're looking at your P&L that has the entire year, you're able to see

trends and you're able to analyze the information see where your strong points

are see when your fees were too high and and you can even get it down to a more

granular level and really have a good understanding by SKU by category but

it's important and key that things are broken out correctly. So just to do

a quick reconciliation if you take your total sales income which includes your

gross sales less returns and refunds from Amazon less your Amazon

delivery and transport less your amazon commission and selling fees less your

Amazon fulfillment and warehousing less your $1,500 sales tax payable that Amazon

collected for you and remitted back to you that equals $95,000

which reconciles out to the net deposit that they sent you. So that is on a basic

level how to correctly record the Amazon activity and break it out on your

balance sheet and P&L. In the next video I will cover additional topics other

issues I found, other ways of accounting accounting for things in a much more

understandable manner so that when owners or managers and executives that

are looking at the financial statements, they really have a good understanding of

how the company is doing. Again please reach out to me if you have any

questions, or if you disagree with what I'm saying, or if you just want to say thanks

for the information Jerry. Anyways been in touch and look forward to the next

video in this series. Thank you!