Line 38: |
Line 38: |
| * Verify that the month you want to import has not already been imported. Reimporting transaction data makes a quick mess in quickbooks. | | * Verify that the month you want to import has not already been imported. Reimporting transaction data makes a quick mess in quickbooks. |
| * Export a single entire completed month only. | | * Export a single entire completed month only. |
− |
| |
| | | |
| * Log into quickbooks at [https://qbo.intuit.com/app/homepage] | | * Log into quickbooks at [https://qbo.intuit.com/app/homepage] |
Line 45: |
Line 44: |
| * Select File Upload | | * Select File Upload |
| * Upload the QBO file you downloaded from the pex site. | | * Upload the QBO file you downloaded from the pex site. |
− |
| |
| | | |
| == Categorizing PayPal == | | == Categorizing PayPal == |
| | | |
− | Paypal Income is handled a little differently from the other accounts. We do not import individual transactions. Instead, we create journal entries from reports | + | Paypal Income is handled a little differently from the other accounts. We do not import individual transactions. Instead, we create journal entries from reports |
| | | |
| === Get Report from paypal === | | === Get Report from paypal === |
Line 56: |
Line 54: |
| * Select the completed month you want to export, and press "View Report" | | * Select the completed month you want to export, and press "View Report" |
| * Once the report is generated, Press "Download" next to the pdf combo box. | | * Once the report is generated, Press "Download" next to the pdf combo box. |
− | * Rename the Downloaded file from ''MonthlyFinancialSummery.pdf'' to ''paypal-YYYY-MM.pdf'' where YYYY is the 4 digit year, and MM is the 2-digit month | + | * Rename the Downloaded file from ''MonthlyFinancialSummery.pdf'' to ''paypal-YYYY-MM.pdf'' where YYYY is the 4 digit year, and MM is the 2-digit month |
| | | |
| === Create Journal Entry in Quickbooks === | | === Create Journal Entry in Quickbooks === |
Line 102: |
Line 100: |
| |} | | |} |
| | | |
− | * The paypal statement lists Debit's as negative. Take the absolute value. | + | * The paypal statement lists Debit's as negative. Take the absolute value. |
| * Ignore '''Transfers & withdrawals''' and '''Purchase activity''' for now, those are handled differently. | | * Ignore '''Transfers & withdrawals''' and '''Purchase activity''' for now, those are handled differently. |
| * Dispute activity may show up as a debit or a credit. Pay attention and make sure it matches in quickbooks. | | * Dispute activity may show up as a debit or a credit. Pay attention and make sure it matches in quickbooks. |
Line 109: |
Line 107: |
| == Resolving == | | == Resolving == |
| | | |
− | Find the receipt in RT for each transaction. | + | Find the receipt in RT for each transaction, or in the area host spreadsheet |
− | | |
− | many of the area hosts have provided helpful spreadsheets for tracking this information down.
| |
| | | |
| === General Area === | | === General Area === |
Line 134: |
Line 130: |
| === Cold Metals === | | === Cold Metals === |
| * [https://rt.pumpingstationone.org/User/Summary.html?id=378 RT:dba] | | * [https://rt.pumpingstationone.org/User/Summary.html?id=378 RT:dba] |
| + | |
| + | === CNC === |
| + | * [https://rt.pumpingstationone.org/User/Summary.html?id=7869 RT:ekobrucki] |
| | | |
| == Category == | | == Category == |
Line 168: |
Line 167: |
| * Software licenses | | * Software licenses |
| ** Going to categorize these as office expenses. The "Regs, licenses, and fees" account will be used for government dealings. | | ** Going to categorize these as office expenses. The "Regs, licenses, and fees" account will be used for government dealings. |
− | * Maid Service | + | * Online ACH Payment 4970812665 To Cleaners (_######8663) |
− | ** We are currently categorizing this as an office expense. | + | ** Flying Broomstick / Office Expense / G&A |
| * Checks | | * Checks |
| ** Office expenses. | | ** Office expenses. |
| + | * Bank detail Chase ACH Payments Monthly Fee |
| + | ** Chase Bank / Bank Charges / G&A |
| + | * SMALL BUSINESS ICPAYMENT |
| + | ** Chase Bank / Laser Cutter Loan / G&A |