B SPED Fiscal File Example

This appendix contains this topic:

• Section B.1, "SPED File Example"

B.1 SPED File Example

|0000|006|0|01072012|31072012|SPED Company|00000000100770||SP|00000000100771|3537305|100773||A|0|

|0001|0|

|0005|SPED Company|10077000|address 10077|10077|complemento 10077|bairro 10077|11550100771|11550100772|[e-mail]|

|0100|Accountant Company 1007700||100770000000005|10077000000001|10077000|Address 1007700|1007700|bairro 1007700|complemento 1007700|11100770000|11100770001|[e-mail]|3537305|

|0150|76420|Sao Paulo Customer|01058|76420000000001||76420000000002|3550308|76420004|Address 76420|76420|complemento 76420|bairro 76420|

|0150|76421|Rio de Janeiro Customer|01058|76421000000001||76421000000002|3304557|76421004|Address 76421|76421|complemento 76421|bairro 76421|

|0150|76430|Sao Paulo Supplier|01058|76430000000001||76430000000002|3550308|764300000|Address 76430|76430|complemento 76430|bairro 76430|

|0150|76431|Rio de Janeiro Supplier 76431|01058|76431000000001||76431000000002|3304557|764310000|Address 7643100|7643100|complemento 7643100|bairro 7643100|

|0175|01072012|10|Address 76431|

|0175|01072012|11|764312|

|0175|01072012|12|complemento 76431|

|0175|01072012|13|bairro 76431|

|0190|EA|Each|

|0200|630897/MRIBRSPED/MRIBRSPED CATALOG NEW|mribrsped dsc1 new|||EA|01|10000001|IPI|85|0001||

|0206||

|0220|EA||

|0200|630900/MRIBRSPED2/MRIBRSPED2 CATALOG NEW|mribrsped2 dsc1 new|||EA|04|12000001|02|85|0001||

|0206||

|0220|EA||

|0400|110100|PURCHASE INDUSTRY SAME STATE|

|0400|210100|PURCHASE INDUSTRY DIFF STATE|

|0400|510100|SALES INDUSTRY SAME STATE|

|0400|610100|SALES INDUSTRY DIFF STATE|

|0460|||

|0990|25|

|C001|0|

|C100|1|0|76420|55|00|007|10087|35120700000000100770550070000100871000006640|01072012|01072012|141,60|1|||120,00|1||||120,00|22,80|||13,20|3,60|4,80|||

|C170|1|630897/MRIBRSPED/MRIBRSPED CATALOG NEW||1,00000|EA|120,00||0|000|5101|510100|120,00|19,00|22,80|||||50||120,00|11,00|13,20|01|120,00|3,0000|||3,60|01|120,00|4,0000|||4,80||

|C176|55|10087|007|01072012|76420|1,000|120,000|120,000|

|C190|000|5101|19,00|133,20|120,00|22,80|0|0|0|13,20||

|C100|1|0|76421|55|00|007|10088|35120700000000100770550070000100881000006656|01072012|01072012|235,40|1|||220,00|1||||220,00|26,40||||6,60|8,80|||

|C170|1|630900/MRIBRSPED2/MRIBRSPED2 CATALOG NEW||1,00000|EA|220,00||0|000|6101|610100|220,00|12,00|26,40|||||52||220,00|||01|220,00|3,0000|||6,60|01|220,00|4,0000|||8,80||

|C176|55|10088|007|01072012|76421|1,000|220,000|220,000|

|C190|000|6101|12,00|220,00|220,00|26,40|0|0|0|0||

|C100|0|1|76430|55|00|001|10475||01072012|01072012|4760,00|1|||5000,00|1||||5000,00|950,00|||110,00|150,00|200,00|||

|C170|1|630897/MRIBRSPED/MRIBRSPED CATALOG NEW||10,00000|EA|1000,00||0|000|1101|110100|1000,00|19,00|190,00|||||00||1000,00|11,00|110,00|||||||01|1000,00|4,0000|||40,00||

|C170|2|630900/MRIBRSPED2/MRIBRSPED2 CATALOG NEW||20,00000|EA|4000,00||0|000|1101|110100|4000,00|19,00|760,00|||||02||4000,00|||||||||01|4000,00|4,0000|||160,00||

|C190|000|1101|19,00|5110,00|5000,00|950,00|0|0|0|110,00||

|C100|0|1|76431|55|00|001|10476||01072012|01072012|1040,00|1|||1000,00|1||||1000,00|120,00|||110,00|30,00|40,00|||

|C170|1|630897/MRIBRSPED/MRIBRSPED CATALOG NEW||10,00000|EA|1000,00||0|000|2101|210100|1000,00|12,00|120,00|||||00||1000,00|11,00|110,00|||||||01|1000,00|4,0000|||40,00||

|C190|000|2101|12,00|1110,00|1000,00|120,00|0|0|0|110,00||

|C100|0|1|76430|01|00|01|10477||01072012|01072012|104,00|1|||100,00|1||||100,00|19,00|||11,00|3,00|4,00|||

|C170|1|630897/MRIBRSPED/MRIBRSPED CATALOG NEW||1,00000|EA|100,00||0|000|1101|110100|100,00|19,00|19,00|||||00||100,00|11,00|11,00|||||||01|100,00|4,0000|||4,00||

|C190|000|1101|19,00|111,00|100,00|19,00|0|0|0|11,00||

|C100|0|1|76430|55|00|000|10478||01072012|01072012|104,00|1|||100,00|1||||100,00|19,00|||11,00|3,00|4,00|||

|C170|1|630897/MRIBRSPED/MRIBRSPED CATALOG NEW||1,00000|EA|100,00||0|000|1101|110100|100,00|19,00|19,00|||||00||100,00|11,00|11,00|||||||01|100,00|4,0000|||4,00||

|C190|000|1101|19,00|111,00|100,00|19,00|0|0|0|11,00||

|C990|23|

|D001|1|

|D990|2|

|E001|0|

|E100|01072012|31072012|

|E110|49,20|0|0|0|1108|0|0|0|0|0|0|0|1058,80|0|

|E500|0|01072012|31072012|

|E510|1101|00|1200|1200|132|

|E510|1101|02|4000|4000|0|

|E510|2101|00|1000|1000|110|

|E510|5101|50|120|120|13,20|

|E510|6101|52|220|220|0|

|E520|0|13,20|242|0|0|228,80|0|

|E990|11|

|G001|1|

|G990|2|

|H001|0|

|H005|31072012|59939,54|01|

|H010|630897/MRIBRSPED/MRIBRSPED CATALOG NEW|EA|132,000|100,128863|13217,01|0|||7670.4122|

|H020|00|2080,00|325,20|

|H010|630900/MRIBRSPED2/MRIBRSPED2 CATALOG NEW|EA|239,000|195,491757|46722,53|0|||7670.4122|

|H020|00|3780,00|733,60|

|H990|7|

|1001|1|

|1990|2|

|9001|0|

|9900|0000|1|

|9900|0001|1|

|9900|0005|1|

|9900|0100|1|

|9900|0150|4|

|9900|0175|4|

|9900|0190|1|

|9900|0200|2|

|9900|0206|2|

|9900|0220|2|

|9900|0400|4|

|9900|0460|1|

|9900|0990|1|

|9900|C001|1|

|9900|C100|6|

|9900|C170|7|

|9900|C176|2|

|9900|C190|6|

|9900|C990|1|

|9900|D001|1|

|9900|D990|1|

|9900|E001|1|

|9900|E100|1|

|9900|E110|1|

|9900|E500|1|

|9900|E510|5|

|9900|E520|1|

|9900|E990|1|

|9900|G001|1|

|9900|G990|1|

|9900|H001|1|

|9900|H005|1|

|9900|H010|2|

|9900|H020|2|

|9900|H990|1|

|9900|1001|1|

|9900|1990|1|

|9900|9001|1|

|9900|9900|41|

|9900|9990|1|

|9900|9999|1|

|9990|44|

|9999|116